Sub total column

[andresf]

Hi,

Can someone please help me with this?

I have this raw data (payment, invoice, invoice value).
What is the formula that I can use to Produce the Total Payment column?

Thanks!

Andres

Payment	Invoice	Invoice value	Total Payment
01	a	100	300 (100+200)
01	b	200
02	c	300	700 (300+400)
02	d	400
03	e	500	500

 

[Fluff]

How about

=IF(COUNTIFS(A$2:A2,A2)=1,SUMIFS(C:C,A:A,A2),"")