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