Hi

=SUMPRODUCT(--($B$4:$AT$4=$C$113),--($B$5:$AT$5=$C$115),$B7:$AT7)/SUMPRODUCT(--($B$4:$AT$4=$C$113),--($B$5:$AT$5=$C$115))

"Karthik" wrote:

Is there a way to find average based on multiple conditions.
I've been using Sumproduct formula to Sum all the cells but not sure how to
use it find average.

=SUMPRODUCT(--($B$4:$AT$4=$C$113),--($B$5:$AT$5=$C$115),$B7:$AT7)

Thanks for your help in advance...
--
Karthi