We have CSV files (I can't provide you the actual files) that have column A with client IDs. Column B has a dollar amount.
There are multiple rows in the CSV file which have the same client IDs. We need a formula which can find all the same client IDs in the document and add the relevant prices together to provide us with a condensed list of client ID and total price for that client.
Example further in bid.
## Deliverables
So for example:
<colgroup> <col width="65" span="2" style="width: 65pt;" /></colgroup>
| Client ID | Price |
| 4899 | 500 |
| 4884 | |
| 4956 | 169.95 |
| 7150 | 149.95 |
| 7199 | 33.25 |
| 7236 | 29.97 |
| 6479 | 29.97 |
| 6610 | |
| 4899 | 35.97 |
| 4884 | 22.72 |
| 4956 | 45.87 |
| 7150 | 31.95 |
| 7199 | 275 |
| 7236 | 33.25 |
| 6479 | 26.95 |
| 6610 | 41.97 |
| 7417 | 33.25 |
| 4896 | 173 |
| 4920 | 424 |
| 4910 | 199.95 |
| 6598 | 180 |
| 4915 | 287.95 |
| 6036 | 199.95 |
| 4912 | 29.97 |
| 7334 | 33.25 |
| 4941 | 139.95 |
| 6036 | 72.95 |
| 4948 | 169.95 |
| 7001 | 35.97 |
| 7355 | 26.95 |
| 4953 | 189.95 |
| 4917 | 190 |
| 4957 | 197.95 |
| 7277 | 28.75 |
| 7400 | 17.47 |
| 6892 | 153.9 |
| 4995 | 32.95 |
| 4891 | 159.95 |
| 5438 | 79.95 |
| 5635 | 139.95 |
| 4899 | 50.97 |
| 4884 | 35.97 |
| 4956 | 89.95 |
| 7150 | 53.98 |
| 4899 | |
As you can see here, client ID 4899 has 4 entries for 500, 50.97, 35.97 and 0.00. I want the new list to have client ID 4899 listed once and the total of the prices (586.94)
Note that these CSV files have thousands of rows (i.e. 10,000) that need to be condensed. Some client IDs are listed 100+ times.