Taryn New Member May 16, 2023 #1 I need my SUMIFS formula to look up column data AND row data to return a result, is this possible? I have typed in a formula in cell B4 of the OUTPUT tab but it obviously doesn't work, any help would be greatly appreciated Attachments Chandoo Template.xlsx Chandoo Template.xlsx 13.9 KB · Views: 9
I need my SUMIFS formula to look up column data AND row data to return a result, is this possible? I have typed in a formula in cell B4 of the OUTPUT tab but it obviously doesn't work, any help would be greatly appreciated
ETAF Active Member May 16, 2023 #2 how about something like =SUMPRODUCT((Data!$Q$7:$AL$17)*(Data!$D$7:$D$17=OUTPUT!B$2)*(Data!$Q$6:$AL$6=OUTPUT!$A4)) but i'm not following your formula for sumif i have added some values - to show the results Attachments Chandoo Template-ETAF.xlsx Chandoo Template-ETAF.xlsx 18.3 KB · Views: 8
how about something like =SUMPRODUCT((Data!$Q$7:$AL$17)*(Data!$D$7:$D$17=OUTPUT!B$2)*(Data!$Q$6:$AL$6=OUTPUT!$A4)) but i'm not following your formula for sumif i have added some values - to show the results
B bosco_yip Excel Ninja May 16, 2023 #5 Or, Try to use Sumif function instead In B4, formula copied across and down: =SUMIF(Data!$D:$D,B$2,INDEX(Data!$1:$1,MATCH($A4,Data!$6:$6,0)))
Or, Try to use Sumif function instead In B4, formula copied across and down: =SUMIF(Data!$D:$D,B$2,INDEX(Data!$1:$1,MATCH($A4,Data!$6:$6,0)))
