Forum Discussion
Total cells if the name/account# in a different cells match.
I have a spreadsheet with different names/account numbers and each line has a payment amount. How do I total only the amounts with the same names/account ID without having to manually Sum the payment amount. What is the formula to total payment amounts IF the name/acct# is identical? I would like a new column to have the total. I need a total for each customer even if there are not multiple payments The only data that I do not have is the TOTAL PAID column which is what I am looking to create.
Example below:
| Tran ID | Tran Post Date | Acct ID | Name | Amount | TOTAL PAID |
| 123489 | 07/16/2024 | 850804 | Paul Armstrong | 70.00 | |
| 123759 | 07/12/2024 | 850804 | Paul Armstrong | 70.00 | 140.00 |
| 135554 | 07/15/2024 | 850805 | Niki Ashton | 140.00 | 140.00 |
| 135578 | 07/25/2024 | 850111 | Karen Webster | 235.00 |
|
| 134469 | 07/26/2024 | 850111 | Karen Webster | 235.00 | 470.00 |
=IF(COUNTIFS($D$2:$D$6,D2,$C$2:$C$6,C2)=COUNTIFS($D$2:D2,D2,$C$2:C2,C2),SUMIFS($E$2:$E$6,$D$2:$D$6,D2,$C$2:$C$6,C2),"")
This formula returns the intended result in my sample file. The formula is in cell G2 and filled down.
