# Total cells if the name/account# in a different cells match.

Copper Contributor

# 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

2 Replies

# Re: Total cells if the name/account# in a different cells match.

=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.

# Re: Total cells if the name/account# in a different cells match.

Alternatively you may use PivotTable to calculate totals for each account