Simple countif syntax request

[Will]

Hi,

I used to use Excel a lot but haven't for a few years. What is the
syntax for using a countif function these days?

"=countif(a1:a10,>b2)" used to do the trick I have tried using help
but for some reason

"=COUNTIF(B29:B40,">B23")"

is not giving me the correct result, ie if I put 6.5 into cell b23 it
is returning 0 not the number of cells in the range B29:B40 which are
greater than 6.5 which is incredibly frustrating!

Thanks,

Will

 

[Pete_UK]

If you have a cell reference as part of the condition, you have to use
the function like this:

=COUNTIF(B29:B40,">"&B23)

Hope this helps.

Pete