Forum Discussion

Nickerz_2020's avatar
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's avatar
    JMB17
    Apr 23, 2021
    Do you have the AverageIf function?

    =AVERAGEIF(I17:O17,">0")
JMB17's avatar
JMB17
Bronze Contributor
Apr 23, 2021
Do you have the AverageIf function?

=AVERAGEIF(I17:O17,">0")
Nickerz_2020's avatar
Nickerz_2020
Brass Contributor
Apr 23, 2021
YES, THAT WAS IT!!!!!! It works. I'm embarrassed to say what my old formula was to accomplish this and thought...there's got to be an easier way - lol!

Thank you JMB17!
  • Nickerz_2020's avatar
    Nickerz_2020
    Brass Contributor
    Apr 23, 2021
    One more thing...

    If the row is all 0% how do I get that same ending cell (P17) to show a 0.00% instead of #DIV/0! I was thinking the =IFERROR and then ,0 at the end but I tried this and it didn't work.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 23, 2021

      Nickerz_2020 

      It shall work

      =IFERROR(AVERAGEIF(I17:O17,"<>0",I17:O17),0)
      • Nickerz_2020's avatar
        Nickerz_2020
        Brass Contributor
        Apr 23, 2021
        Yes, that worked perfectly! Thank you Sergei!

        I really appreciate all the support in this forum. Thank you everyone.

Resources