Excel COUNTIF Compare To Another Cell Value

So in Excel, the COUNTIF function is very useful. However, I couldn’t figure out how to just use COUNTIF to only count cells if another cell is greater than 0. So here is how you do it:

=COUNTIF(Y12,">=" & $Z$3)

Basically, put your operatorĀ in quotes, then use the ampersand, followed by the cell that you want to compare to. Simple!

credit here

Advertisements