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