Forum Discussion
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...
- Do you have the AverageIf function?
=AVERAGEIF(I17:O17,">0")
Do you have the AverageIf function?
=AVERAGEIF(I17:O17,">0")
=AVERAGEIF(I17:O17,">0")
- 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!- 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.
