Count if higher than a cell with formula

[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

 

[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.

 

[Guest]

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
(e-mail address removed)

----- 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

 

[Shona]

Thank you that's great

Hi Shona


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