Calculate Sum of values based on groupings.

[h2lm2t]

I am looking for a way/function to calculate SUM values in ColumnC based in the following data:

Column C needs to sum all the values in Column B as long as the grouping in ColumnA is the same.

Each row in Column C generates value 0 if the row1 colA and row2 colA are the same, otherwise it aggregates the sum values with the same group in Column A.

A B C
10 1 0
10 2 0
10 3 0
10 4 10
20 5 0
20 6 11
30 7 0
30 8 0
30 9 0

Please kindly let me know. Thanks in advance!

-Sam

 

[barry houdini]

Hello Sam,

Welcome to MrExcel. Assuming your data starts in row 1 try this formula in C1 copied down

=IF(A1=A2,0,SUMIF(A:A,A1,B:B))

Note: this post is duplicated, can you delete the other one, please. [click on the X to delete]

 

[h2lm2t]

It works!! Thank you so much Barry! You rock!

 

[h2lm2t]

Quick questions. What if the the data doesn't start in row 1?

Thanks,
SAM

 

[barry houdini]

You can adjust accordingly...e.g. if data starts at row 5 then use this formula in C5 copied down

=IF(A5=A6,0,SUMIF(A$5:A5,A5,B$5:B5))