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

%3CLINGO-SUB%20id%3D%22lingo-sub-2378768%22%20slang%3D%22en-US%22%3Esumifs%20formula%20criteria%20range%20is%20vertical%20%26amp%3B%20horizontal%20both%20den%20how%20to%20do%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378768%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20help%20for%20sumifs%20formula%20criteria%20range%20is%20vertical%20%26amp%3B%20horizontal%20both%20den%20how%20to%20do%3F%3C%2FP%3E%3CP%3EPls%20find%20in%20attached%20file%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%20%3A-%20to%20set%20formula%20in%20%22Master%22%20Sheet%2C%20Cell%20P3%2C%20Criteria%20selection%20is%20from%20%22Summary%22%20Sheet%26nbsp%3B%20Column%20C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2378768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378785%22%20slang%3D%22en-US%22%3ERe%3A%20sumifs%20formula%20criteria%20range%20is%20vertical%20%26amp%3B%20horizontal%20both%20den%20how%20to%20do%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378785%22%20slang%3D%22en-US%22%3EHi%20Aman%2C%3CBR%20%2F%3EPls%20put%20clear%20what%20u%20want%20to%20achieve%20with%20the%20formula%3C%2FLINGO-BODY%3E
New Contributor

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)