">=" usage in a function

[Shane R. Pouch]

Hello to all,

I have the following function that I'm using without incident -
COUNTIF(L12:L65536,">=4"). It simply tells me how many times the value 4 or
larger exists in column "L" between rows 12 and 65536.

However, I want to be able to change "4" to a cell reference, where I can
put in any value I want. But, for some reason the following will not work
COUNTIF(L12:L65536,">=A4"). I even tried this COUNTIF(L12:L65536,>=A4) with
no luck.

I'm stumped - what is the proper syntax??

 

[T. Valko]

Try it like this:

=COUNTIF(L12:L65536,">="&A4)

 

[Shane R. Pouch]

Ah yes! Worked nicely - Thanks!

Try it like this:

=COUNTIF(L12:L65536,">="&A4)

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Ah yes! Worked nicely - Thanks!