Sumif from mutliple sheet.

[Shabbo]

Dear Sir,
I wanted to apply sumif,
if not found in sheet1 then should find from sheet2.

 

[Juniad]

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]

you can to Use this ,

=SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!"&"a2:a1000"),$A2,INDIRECT("'"&Sheets&"'!"&"b2:b1000")))