Count if higher than a cell with formula

S

Shona

I want to be able to count the number of figures that are higher than
another cell which has the mode formula in it?

Does anyone know how I do this?

Cheers

Shona
 
R

Roger Govier

Hi Shona


With your data in cells B1:B20 and the mode formula in C1
Try
=COUNTIF(B1:B20,">"&C1)
Change ranges to suit.
 
M

Mark Graesser

Shona,
The following formula will count the figures in A1 through A10 that are higher than the value in B1:


=COUNTIF(A1:A10,">"&B1)

Good Luck,
Mark Graesser
[email protected]

----- Shona wrote: -----

I want to be able to count the number of figures that are higher than
another cell which has the mode formula in it?

Does anyone know how I do this?

Cheers

Shona
 
S

Shona

Thank you that's great
Roger Govier said:
Hi Shona


With your data in cells B1:B20 and the mode formula in C1
Try
=COUNTIF(B1:B20,">"&C1)
Change ranges to suit.
Click to expand...
 
Top