Sum of 2 columns based on 3rd column reference

[Plasticman]

Hi All,

Been awhile.

I have 3 columns
Column A Column B Column C
REFER1 10
REFER1 5
REFER2 11
REFER2 6
REFER3 12
REFER3 6

Column A Bank Reference - which I sorted using conditional formatting
Column B Money paid in
Column C Bank Charge

I need a formula that matches the reference to give me
REFER1 = 15
REFER2 = 17
REFER3 = 18

I will use conditional formatting to send unique references (Column A) to another sheet.
So references will always be paired.

Any help would be great.
Thanks in advance.

[Punnam]

=SUMIF(A:A,C1,B:B)
c1 is "REFER1",
c2 IS"REFER2", ETC.

PUNNAM

[AlKey]

=SUMIF($A$2:$A$7,C2,$B$2:$B$7)

	A	B	C	D
1	Bank Reference	Money	SUM IF
2	REFER1	10	REFER1	15
3	REFER1	5	REFER2	17
4	REFER2	11	REFER3	18
5	REFER2	6
6	REFER3	12
7	REFER3	6