sumifs formula criteria range is vertical & horizontal both den how to do?

Occasional Visitor

Need help for sumifs formula criteria range is vertical & horizontal both den how to do?

Pls find in attached file 

Sheet :- to set formula in "Master" Sheet, Cell P3, Criteria selection is from "Summary" Sheet  Column C

 

2 Replies
Hi Aman,
Pls put clear what u want to achieve with the formula

@Amann1724 

Perhaps

=SUMPRODUCT(('Summary ( All)'!$C$5:$C$59=$A3)*('Summary ( All)'!$AZ$2:$QE$2=$B3)*('Summary ( All)'!$AZ$3:$QE$3=P$1)*('Summary ( All)'!$AZ$4:$QE$4=P$2),'Summary ( All)'!$AZ$5:$QE$59)