Excel 2008 : HELP NEEDED! Sum values of one column based on a changing critiera in another column

Hi,

Looking for a solution to the following:

In column E, I want the sum of values in Column G, which have the same values in Column A
So the sum critieria is based on Column A and the values to be summed are in Column G.

In the example I have manually inserted the desired values in Column G but would like a formula to do this as I have over 20K lines of data.

Anyway got a soultion??

Hennerby

Hi DILIPandey,

Thanks for your reply but unfortunately that formula will not work in this instance.
In the example shown the values in Column E are those which the formula should generate, keeping in mind that the same formula will have to be applied to the entire column due the the large number of rows. By using your SUMIF formula you will generate an entire column of values.

Rgds,
Hennerby

Originally Posted by romperstomper

Can't you use a pivot table? If not, then I'd just change Dilipandey's formula to
=IF($A2=$A1,"",SUMIF($A$2:$A$33,$A2,$D$2:$D$33))

Hi romperstomper,

Sorry for the lack of reply on this post, I had eventually come to this conclusion but thank you for the post!

Thanks,
Hennerby