How to calculate running totals of subsets of data in a table

Posted by John on Super User See other posts from Super User or by John
Published on 2012-06-02T02:20:51Z Indexed on 2012/06/03 10:43 UTC
Read the original article Hit count: 135

Filed under:
|

I have 4 columns: Name, Week, Batch and Units Produced (Cols, A,B,C,D). In column E, I need to keep running totals based on name and week. When the week changes for the same person, restart the total.

Fred, 12, 4001, 129.0    Answer in e:  129.0
Fred, 12, 4012, 234.0    Answer in e:  363.0
Fred, 13, 4023, 12.0     Answer in e:  12.0

John, 12, 4003, 420.0    Answer in e:  420.0
John, 13, 4021, 1200.0   Answer in e:  1200.0
John, 13, 4029, 120.0    Answer in e:  1320.0

I need to be able to copy the formula to over 1000 rows.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about sum