Sum up all line items with the same reference

[egmax5]

Hi,
Im doing a bank recon macro and it needs summing up of line items with the same reference.
How do I sum up line items that has teh same reference, below is my sample

Col A Col B Col C Col D
20060906 AB (3,651.43) (4,513.03)
20060906 AB (861.60) (4,513.03)
20060906 ZP (634.00) (634.00)
20060906 ZP (28,500.00) (28,500.00)
20060906 YY (13,899.64) (14,899.64)
20060906 YY (1,000.00) (14,899.64)

My reference are Col A and Col B, line items should have the same colA and colB before i sum up their amount and put it in colD.

Thanks you.
egmax

 

[CaptainD]

What have you tried?

 

[mintjulep]

sumif()

 

[misterstick]

assumes row 2:

[tt]=SUMIF($B$2:$B$7, "="&B2, $C$2:$C$7)[/tt]

hth,

mr s. <

 

[SkipVought]

How about Data/Subtotals...


This is not a VBA question, it seems.

Skip,

_[red][/red]

 

[wom2007]

Hi, You need to use a SumProduct function. You do not need to use VBA code for this. I have done similar analysis using a SumProduct and it works. Try it out and let me know if this works for you.