Sum if with multiple column.

[Sarfraz Khan]

dear sir,

i have data in two column B and E on sheet 2 I wanted the amount using sumif on the basis of Number as eg mentioned in the sheet.

Thanks.

 

[NARAYANK991]

Hi ,

Try this :

=SUMIF(Sheet1!$D$3:$D$10,Sheet2!$B3,Sheet1!$C$3:$C$10) + SUMIF(Sheet1!$H$3:$H$10,Sheet2!$B3,Sheet1!$G$3:$G$10)

Narayan

 

[Sarfraz Khan]

Hi ,

Try this :

=SUMIF(Sheet1!$D$3:$D$10,Sheet2!$B3,Sheet1!$C$3:$C$10) + SUMIF(Sheet1!$H$3:$H$10,Sheet2!$B3,Sheet1!$G$3:$G$10)

Narayan

Gr8 sir.Thanks a lot.

 

[Vijay Dhangar]

Try this also..... :





=LOOKUP(B3,Sheet1!$D$3:$D$10,Sheet1!$C$3:$C$10)+LOOKUP(B3,Sheet1!$H$3:$H$10,Sheet1!$G$3:$G$10)