Average a column with zeros

Scott Verduin

Hello,

How do you average column and not include the cells with zeros in them.

Value 1

Value 1

Value 1

Value 0

Value 1

This column will grow larger and larger as more form data comes in.

Thank you

Andrée Starå

Hi Scott,

Try something like this.

=AVERAGEIF(Value:Value; >0)

The same version but with the below changes for your and others convenience.

=AVERAGEIF(Value:Value, >0)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

You can try an AVERAGEIF.

=AVERAGEIF([Number Column]:[Number Column], @cell <> 0)