How to calculate running totals of subsets of data in a table
- by John
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,…