MichielV
12-04-2012, 04:46 PM
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
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