If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Countif Formula
I am using a formula in cell C1
=3Dcountif(B9:B500,"500") This formula will look in column B (which is a column with=20 values in =A3's) and tell me how many rows have a value of=20 under =A3500 in Coloumn B I want a formula like above that will say under =A3500 but=20 over =A3700 |
#2
|
|||
|
|||
Countif Formula
wrote in message
... I am using a formula in cell C1 =countif(B9:B500,"500") This formula will look in column B (which is a column with values in £'s) and tell me how many rows have a value of under £500 in Coloumn B I want a formula like above that will say under £500 but over £700 Please don't keep starting new threads with the same question! Look at the replies you receive. If you want to follow these up, by all means do so but by replying in the same thread. |
#3
|
|||
|
|||
Countif Formula
SORRY !!!!
-----Original Message----- wrote in message ... I am using a formula in cell C1 =3Dcountif(B9:B500,"500") This formula will look in column B (which is a column with values in =A3's) and tell me how many rows have a value of under =A3500 in Coloumn B I want a formula like above that will say under =A3500 but over =A3700 Please don't keep starting new threads with the same=20 question! Look at the replies you receive. If you want to follow these up, by=20 all means do so but by replying in the same thread. . |
#4
|
|||
|
|||
Countif Formula
And it is an invalid combination to be under £500 and over £700!!!
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Paul" none wrote in message ... wrote in message ... I am using a formula in cell C1 =countif(B9:B500,"500") This formula will look in column B (which is a column with values in £'s) and tell me how many rows have a value of under £500 in Coloumn B I want a formula like above that will say under £500 but over £700 Please don't keep starting new threads with the same question! Look at the replies you receive. If you want to follow these up, by all means do so but by replying in the same thread. |
#5
|
|||
|
|||
Countif Formula
Bob,
I meant, over =A3500 and under =A3700 !!!!!!! -----Original Message----- And it is an invalid combination to be under =A3500 and=20 over =A3700!!! --=20 HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Paul" none wrote in message=20 ... wrote in message ... I am using a formula in cell C1 =3Dcountif(B9:B500,"500") This formula will look in column B (which is a column=20 with values in =A3's) and tell me how many rows have a value of under =A3500 in Coloumn B I want a formula like above that will say under =A3500 but over =A3700 Please don't keep starting new threads with the same=20 question! Look at the replies you receive. If you want to follow these up, by=20 all means do so but by replying in the same thread. . |
#6
|
|||
|
|||
Countif Formula
Hopefully you've got your answer in the other thread.
Bob wrote in message ... Bob, I meant, over £500 and under £700 !!!!!!! -----Original Message----- And it is an invalid combination to be under £500 and over £700!!! -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Paul" none wrote in message ... wrote in message ... I am using a formula in cell C1 =countif(B9:B500,"500") This formula will look in column B (which is a column with values in £'s) and tell me how many rows have a value of under £500 in Coloumn B I want a formula like above that will say under £500 but over £700 Please don't keep starting new threads with the same question! Look at the replies you receive. If you want to follow these up, by all means do so but by replying in the same thread. . |
Thread Tools | |
Display Modes | |
|
|