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!