Leave zeros out of an average

Premium

The store is closed on Mondays and Sundays and records 0 sales. In E1, find the average sales of the days it was open: AVERAGEIF with the condition ">0".

E1
ABCDEF
1Day Sales Avg. open day
2Monday 0
3Tuesday 840
4Wednesday 760
5Thursday 910
6Friday 1120
7Saturday 1370
8Sunday 0
9

Premium lesson

Unlock AVERAGEIF and AVERAGEIFS and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:SUMIFSCOUNTIFS

It comes up in this mock test: Excel assessment (Indeed format)

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?