R Rahul Mishra Member Sep 8, 2016 #1 Dear sir, want to data thru match required output example is available in excel sheet. Attachments Question.xlsx 567.8 KB · Views: 6
S sdsurzh Member Sep 8, 2016 #2 =SUMIFS('Raw data'!$E:$E,'Raw data'!$A:$A,'Question sheet'!$A3,'Raw data'!$D:$D,'Question sheet'!C$2) try this
=SUMIFS('Raw data'!$E:$E,'Raw data'!$A:$A,'Question sheet'!$A3,'Raw data'!$D:$D,'Question sheet'!C$2) try this
S sdsurzh Member Sep 8, 2016 #3 also you can use match index using array =IFERROR(INDEX('Raw data'!$A$1:$E$17665,MATCH(1,('Raw data'!$A$1:$A$17665=$A3)*('Raw data'!$D$1:$D$17655=C$2),0),5),0) Use Ctrl + Shift + Enter
also you can use match index using array =IFERROR(INDEX('Raw data'!$A$1:$E$17665,MATCH(1,('Raw data'!$A$1:$A$17665=$A3)*('Raw data'!$D$1:$D$17655=C$2),0),5),0) Use Ctrl + Shift + Enter
B bosco_yip Excel Ninja Sep 8, 2016 #4 The SUMIFS formula here's modified to remove 0 In C3, copy across and down : =IFERROR(1/(1/SUMIFS('Raw data'!$E:$E,'Raw data'!$A:$A,'Question sheet'!$A3,'Raw data'!$D:$D,'Question sheet'!C$2)),"") Regards Bosco
The SUMIFS formula here's modified to remove 0 In C3, copy across and down : =IFERROR(1/(1/SUMIFS('Raw data'!$E:$E,'Raw data'!$A:$A,'Question sheet'!$A3,'Raw data'!$D:$D,'Question sheet'!C$2)),"") Regards Bosco
