Sum IF

[deen]

Hi,

Can u pls help me regarding Sum If,

in sheet1 we have code and amt ,

we need result in sheet2 with A2 column reference sum of code value.

In Sheet 1

Code Amt
F001 10
F001 20
F002 40
F001 30
F002 50


We need Result in sheet2 like a,
Code Amt
F001 60
F002 90

Regards

Deen

 

[Guest]

sheet 2

B2: =SUMIF(Sheet1!$A$2:$A$6,Sheet2!A2,Sheet1!$B$2:$B$6)
copy down

 

[Guest]

Assuming code is in Column A and amount is in Column B, on Sheet2 enter
following formulas for the example codes:
=SUMIF(Sheet1!A:B,"F001",Sheet1!B:B)
=SUMIF(Sheet1!A:B,"F002",Sheet1!B:B)