Datatellsall2
New Member
- Joined
- Jul 17, 2018
- Messages
- 23
Hello -
I'm looking to calculate cumulative totals and percentages based on the type of data in column A (unique company code identifier) and column B (date of time entry). My time data is in column C (formatted as an integer). I would only like to calculate the cumulative total & % if the row data agrees to the unique identifier. I have roughly 5000 lines of data. Should I be utilizing a mix of Vlookup and Sum functions here?
<tbody>
</tbody>
Any help would be greatly appreciated.
Thanks,
M
I'm looking to calculate cumulative totals and percentages based on the type of data in column A (unique company code identifier) and column B (date of time entry). My time data is in column C (formatted as an integer). I would only like to calculate the cumulative total & % if the row data agrees to the unique identifier. I have roughly 5000 lines of data. Should I be utilizing a mix of Vlookup and Sum functions here?
Unique Identifier | Date | Time Amount (hrs) | Cumulative Total | Cumulative % |
100 | 1/1/18 | 3 | ||
100 | 1/2/18 | 4 | ||
100 | 1/5/18 | 5 | ||
101 | 1/1/18 | 2 | ||
101 | 1/9/18 | 3 | ||
105 | 1/21/18 | 10 | ||
105 | 1/22/18 | 8 |
<tbody>
</tbody>
Any help would be greatly appreciated.
Thanks,
M