Find SUM by group

[djl0525]

Hi...

In column A, I have numbers like

1
1
2
2
2
3
3

I call these groups. Group 1 contains two rows. Group 2 contains 3 rows. Group 3 contains 2 rows... and so on.

In column F, I need to sum the values that are in column E for each group as indicated in col A.

If group 1 adds up to 100, column F will say

100
100

If group 2 adds up to 350, column F will say

350
350
350

...and so on.

Can someone tell me the formula to add column E by group, please?

Thanks,
DJ

 

[Fluff]

Assuming your data starts in A1 put this in F1
=SUMIF(A$1:A$7,A1,E$1:E$7)
changing the values in red to match your range

 

[PCL]

Not sure to have a clear understanding of the need but perhaps try:
F6 = A6+A1
Copy and paste down as needed

 

[djl0525]

Thanks Fluff. SUMIF works perfectly!

Thanks for your time. PCL.

DJ

 

[Fluff]

Glad to help & thanks for the feedback