Previous Topic Next Topic

Can the formula COUNTA / COUNT exclude 0 values?

Solved/Closed
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - Apr 28, 2014 at 11:59 AM
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - Apr 28, 2014 at 01:46 PM
If I use COUNT or COUNTA, what can I include in the formula to exclude zero values?

Thanks for any tips
Related:

2 responses

Answer 1 / 2
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014
Apr 28, 2014 at 01:46 PM
Oh great - thanks
that works fine

Similar discussions

Counting number of times a value appears if..
jensorr -
sambr22 -

7 responses
Grey out an entire row in Excel 2010 depending on a cell's value
deeptis -
T -

11 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses