Countif() formula

[nikos]

Hi
I have a column in Excel, D7200, filled of real numbers. Also the cell F3
includes a number (variable cell).
I would like to count how many numbers of the column D7200 are >F3, but in
successive ranges of D column.
(That means how many numbers in: D78 > F3, D78 > F3, D79 > F3…………….and
finally D7200 > F3).

To do that I have applied in E7 the formula:

Countif(D7:$D$7 ; “>F3â€) and expand down to E200.

Unfortunately the above formula returns zero in all applied cells.
If I change the F3 in the formula using a stable number (2,3,4 etc) the
formula works, but I need the F3 cell to be changeable.
I thought that Countif() can accept, changeable criteria.

What goes wrong and how can I fix it.
Thank you.

 

[Alan]

Try,
=COUNTIF(D7:$D$7,">"&$F$3)
Regards,
Alan.

 

[Roger Govier]

Hi

Change your formula to
=COUNTIF($D$77; ">"&$F$3)

By Enclosing the F3 within the quotes, as you had, meant that Countif was
comparing the cells with "F3" (of which there are none), rather than the
contents of F3.

 

[nikos]

Thanks a lot. I tried and it worked. But please tell me tell me how could I
learn these “extra†forms (“>â€&). The help topic of countif() function didn’t
say anything. Where can I search for more information and these extra
“tricks�