Named Formula and CountIF

[Rico Mawcinitt]

I am using a named range within a countif formula and running into some issues.

Example -

=countif("NamedRange",">C19") is showing 0

but when i replace C19 with the actual number C19 is referencing

=countif("NamedRange",">1050) is showing the true number of 29

Any help would be greatly appreciated.

Thank you,
Rico

 

[Rico Mawcinitt]

My formula does work if I change it to

=COUNT(IF(NamedRange>C19,NamedRange))

I must be missing the logic that countif applies. I would still like to better understand the countif formula.

 

[Hui]

Rico

try: =Countif(NamedRange,">"&C19)

Putting quotation marks around the NamedRange converts the name to Text and the same happens with the address C19

">&C19" means a Text String ">&C19"

">"&C19 means Greater than the value in cell C19

 

[Rico Mawcinitt]

That worked

Thank you Hui!