Forum Discussion

Nickerz_2020

Brass Contributor

Apr 23, 2021

Solved

Is There An Easier Way?

I have cells that show a % (i.e., 40%, 45%, etc.) for each day of the week (Monday-Sunday). I'm trying to get the average for the entire week but some days are 0%. I tried using the following formu...

Formulas and Functions

JMB17
Apr 23, 2021
Do you have the AverageIf function?

=AVERAGEIF(I17:O17,">0")

Riny_van_Eekelen

Platinum Contributor

Apr 23, 2021

Nickerz_2020 Use AVERAGE like this:

=AVERAGE(I7:O7)

Nickerz_2020

Brass Contributor

Apr 23, 2021

Hi Riny,

I tried your formula but then I get 13000% so then I typed in the following formula (thinking it should be 17 not 7) but I get the same result as my original formula...

=AVERAGE(I17:O17)