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