Sum If if Cell A Cell B and Cell C has similar data from other sheet

[surazshrestha]

Hi,

I am trying to sum if Cell A /Cell B /Cell C has similar data on other sheet Cell A /Cell B / Cell C. But unable appreciate if your help.

Cell A contains BLDG Name, Cell B contains City Name, Cell C contains PIN Code and Cell D contains 10,000 on sheet 1

If it has multiple same entry on different rows on same sheet, then sum or error...

Appreciate your help..thanks

 

[surazshrestha]

Thanks guys...I figured out ..it is =SUMIFS(Inbound!I2:I10,Inbound!C2:C10,C3,Inbound!F2:F10,D3,Inbound!G2:G10,'Stock On Hand'!E3)