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?
 
You must log in or register to reply here.

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
CELL EQUALS LAST NONBLANK CELL IN A COLUMN 5
Filter nonblanks from sheet into single column 1
Countif for 2 columns 3
How to filter & aggregate nonblank cells that all contain formulas 2

Back
Top