Dear Sir, I wanted to apply sumif, if not found in sheet1 then should find from sheet2.
S Shabbo Member Apr 1, 2020 #1 Dear Sir, I wanted to apply sumif, if not found in sheet1 then should find from sheet2. Attachments Sumif Help.xlsx 9.1 KB · Views: 10
Juniad Active Member Apr 1, 2020 #2 try this in sheet3 cell B2 =IF(SUMIF(Sheet1!$A:$A,Sheet3!A2,Sheet1!$B:$B)<1,SUMIF(Sheet2!$A:$A,Sheet3!A2,Sheet2!$B:$B),SUMIF(Sheet1!$A:$A,Sheet3!A2,Sheet1!$B:$B))
try this in sheet3 cell B2 =IF(SUMIF(Sheet1!$A:$A,Sheet3!A2,Sheet1!$B:$B)<1,SUMIF(Sheet2!$A:$A,Sheet3!A2,Sheet2!$B:$B),SUMIF(Sheet1!$A:$A,Sheet3!A2,Sheet1!$B:$B))
herofox Active Member Apr 2, 2020 #3 you can to Use this , Code: =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!"&"a2:a1000"),$A2,INDIRECT("'"&Sheets&"'!"&"b2:b1000"))) Attachments Sumif Help.xlsx 12.1 KB · Views: 5
you can to Use this , Code: =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!"&"a2:a1000"),$A2,INDIRECT("'"&Sheets&"'!"&"b2:b1000")))