Ask a question Report

Closed]

doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen - Apr 28, 2014 at 11:59 AM - Latest reply: doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen

- Apr 28, 2014 at 01:46 PM

Excel Ask a question Report

If I use COUNT or COUNTA, what can I include in the formula to exclude zero values?

Thanks for any tips

2 replies

Report Respond to doublewitt

doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen - Apr 28, 2014 at 01:46 PM

Thank you

Oh great - thanks
that works fine

Report Respond to aquarelle

aquarelle 7178 Posts Saturday April 7, 2007Registration dateModeratorStatus May 25, 2018 Last seen - Apr 28, 2014 at 01:09 PM

-1

Thank you

Hello

You should use COUNTIF(range,criteria)

If your data are in range A2 to A33, to exclude zero value, you can use this formula :
=COUNTIF(A2:A33,"<>0")

Regards

Ask a question

Can the formula COUNTA / COUNT exclude 0 values? [Solved/Closed]

Your reply