May 23 2021 01:01 AM
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
May 23 2021 01:12 AM
May 23 2021 01:16 AM
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)