Hello everybody!
I have a column of ever increasing Numeric Values. Some of them are 0's. I need to count the number of non-zero values, only.
Any help will be appreciated.
Hello everybody!
I have a column of ever increasing Numeric Values. Some of them are 0's. I need to count the number of non-zero values, only.
Any help will be appreciated.
for data in column A
=COUNTIF(A:A,">0")
=COUNTIF(A1:A15;">0")
Adjust the A1 and A15 to match your data range
Thank you very much, AlanY, for the help. Have a nice time.
you're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks