help with a formula for counting

  • Thread starter Thread starter wwoody
  • Start date Start date
W

wwoody

I have numbers in col d and have done
=count(d3:d70) which gives me total of
items but i would like to modify it to only
add 1 if the cell is <> 0.
can anybody showme how to do this?
 

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

Column number of last column that returns value ignore formulas 8
Cell Count Between Value 13
creating a formula 3
Item Count vs Item Cost 1
In VBA how to select the right format for a range 7
Counting Criteria Values with For Loop 3
Excel Need Countifs Formula Help 0
Offset Count if, between two words! 2

Back
Top