Sum IF
 

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

Sum IF
 

sheet 2

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

"deen" wrote:

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

Sum IF
 

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)


"deen" wrote:

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