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")
Not sure why do you have an error, I attached sample file to check the formula. In my case it works. Appreciate if you show what's wrong in it, will be useful.
Hi Sergei,
Looking back at my post @ 3:30pm above, I tried using several variations that didn't work but not sure if I was using them correctly. Can you reply with the exact formula you are referring to, then I can copy and paste it to know for sure?
The formula that is now in this cell now (I think this is the one as there were a few cells I was getting help with) is the following formula...
=IFERROR(SUM(S33,AC33,AM33,AW33,BG33,BQ33,CA33)/INDEX(FREQUENCY((S33,AC33,AM33,AW33,BG33,BQ33,CA33),0),2),0)
Thank you.
Looking back at my post @ 3:30pm above, I tried using several variations that didn't work but not sure if I was using them correctly. Can you reply with the exact formula you are referring to, then I can copy and paste it to know for sure?
The formula that is now in this cell now (I think this is the one as there were a few cells I was getting help with) is the following formula...
=IFERROR(SUM(S33,AC33,AM33,AW33,BG33,BQ33,CA33)/INDEX(FREQUENCY((S33,AC33,AM33,AW33,BG33,BQ33,CA33),0),2),0)
Thank you.
Sorry, have no idea on which post you give reference as "my post @ 3:30pm above,". Site shows my local time which is most probably not the same as for your timezone.
As for the formula you may find it in the file attached to my previous post.