Count Of Numbers Greater Than Zero In Excel Sheet Using Formula

[MichielV]

I have a column with values and empty cells. I have made a link to another sheet and the empty cells appear as zero then. So the column looks like this:

0
3030
5798
3009
3730
2778
4987
7477
0
0
16960
0
25349
0
0
0
0

Now, I would like to no how many values if have got in the whole column (so not the zero's). Is there a formula to do so? I was thinking about the IF>0 stuff..

Many thanks

[Admin]

Hi MichielV,

Welcome to ExcelFox !!

To count the numbers greater than 0, try

=COUNTIF(A2:A100,">0")

adjust the range.