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

Question

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

Report

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

Excel count exclude zero and blank
Excel count exclude zero - Best answers
Excel count ignore zero - Best answers
Excel count names in list - How-To - Excel
Excel - Count rows where 2 conditions are true - How-To - Excel
Excel - Counting number of days between two entries - How-To - Excel
Excel - Count 2 values in one column and 1 value in other - How-To - Excel
Excel count number of occurrences in a column - How-To - Excel

2 replies

Ask a question

doublewitt · Answer 1 · 2014-04-28T13:46:30-0400

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

aquarelle · Answer 2 · 2014-04-28T13:09:05-0400

Answer 2 / 2

aquarelle

Posts: 7083
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: September 25, 2020

477
Apr 28, 2014 at 01:09 PM

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

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

2 replies

Your reply

Subscribe To Our Newsletter!