I need to COUNT data greater than zero, but count if is not working!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to count cells that have numbers greater than zero. How do do this? I've tried Count (Range,>1) but this does not work. My data looks something like this

123
111

154

456
I'm trying to come up with a COUNT formula with the answer of 4.
 
Back
Top