Countif Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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)
 
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 news:[email protected]... all means do so
but


.
Click to expand...
 
Hopefully you've got your answer in the other thread.

Bob

Bob,

I meant, over £500 and under £700 !!!!!!!
 
Back
Top