Hi , I need help with a formula to sum a running total based on the values contained in column A that sums the values in column B
Hopefully the example below outlines the requirement.
Any help is greatly appreciated.
Hopefully the example below outlines the requirement.
Any help is greatly appreciated.
| policy id | Commission | Running Commission |
| Test1 | 1.00 | 1.00 |
| Test1 | 1.00 | 2.00 |
| Test1 | 1.00 | 3.00 |
| Test1 | 1.00 | 4.00 |
| Test2 | 1.00 | 1.00 |
| Test2 | 1.00 | 2.00 |
| Test2 | 1.00 | 3.00 |
| Test3 | 1.00 | 1.00 |
| Test3 | 1.00 | 2.00 |
| Test3 | 1.00 | 3.00 |
| Test3 | 1.00 | 4.00 |
| Test3 | 1.00 | 5.00 |
