Previous Topic Next Topic

Can the formula COUNTA / COUNT exclude 0 values?

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

Thanks for any tips
Related:

2 responses

Réponse 1 / 2
doublewitt Posts 14 Registration date Sunday 27 April 2014 Status Member Last seen 29 September 2014
28 Apr 2014 à 13:46
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