Hi -
This is a continuation of a previous thread, here; this thread dealt with only 2 (not 3) criteria.
The formula that I am currently using gives me incorrect values.
=AVERAGE(IF($A$3:$A$277=$Q$4, IF($B$3:$B$277=$Q$5, IF($C$2:$N$2=R$4, IF($C$3:$N$277<>"",$C$3:$N$277)))))
Please let me know if you have any suggestions. Best!
Average Formula Error_2.xlsx
Hi,
I don't understand your expected results. I would've thought the (array) formula in R5 should be:
=AVERAGE(IF($C$2:$N$2=R$4,IF($B$3:$B$277=$Q5,IF($A$3:$A$277=$Q$4,IF($C$3:$N$277<>"",$C$3:$N$277)))))
Edit: the formula in your attachment does not match that in your thread.
Regards
Last edited by XOR LX; 05-22-2014 at 11:06 AM.
Hi -
I accidentally uploaded the incomplete version of the file - sorry! I was actually using the same formula as you proposed, and it is giving me incorrect results.
I have attached the updated version with the formula v. expected averages.
Thanks for all your help!
Average Formula Error_2_Fixed.xlsx
I still don't see how you arrive at your expected results. The results seem correct to me.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks