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

R

Razaman

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Adding recognised Zeros 5
Count Number of Unique Cells That Don't Have Certain Characters 0
Countif and values greater than zero for a named range 1
count the number of rows with entries greater than zero 1
How do I count only if either/ or exist 5
Multiple arguments 3
Count IF 2

Top