Count if higher than a cell with formula

  • Thread starter Thread starter Shona
  • Start date Start date
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
 
Hi Shona


With your data in cells B1:B20 and the mode formula in C1
Try
=COUNTIF(B1:B20,">"&C1)
Change ranges to suit.
 
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
 
Back
Top