How to count the occurrence?

E

Eric

Does anyone have any suggestions on how to count the values? which is no
zero. For example, there is a list of numbers under column A,
100,2,0,3,6,0,5,3
I would like to count the number, which is not equal to zero, and it should
return 6 in cell B1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 

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

Top