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