Count if NonBlank and <> 0?

S

skinnyboy77

Joined
Apr 10, 2008
Messages
1
Reaction score
0
I have a range of data in A1:A500. I need a formula that will tell me how many cells in that range are both nonblank and not equal to zero. Help?
 

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

Get Last NonBlank Value 5
Count NonBlank Rows with Criteria in another column 5
count nonblank cells 3
count nonblank cells with conditions 2
Countif for 2 columns 3
How do I count nonblank cells that meet criteria in another cell? 13
Display first, second, etc Nonblank Cells in a Range 12
How do I countif the criteria is a nonblank? 3

Top