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?
 
Back
Top