I have a list of customers with loan balances. Some customers have more than one balance. I need a formula to total the balances by customer so I can use that total in another worksheet. I've included a basic worksheet for example. Thanks!
I have a list of customers with loan balances. Some customers have more than one balance. I need a formula to total the balances by customer so I can use that total in another worksheet. I've included a basic worksheet for example. Thanks!
Use
=SUMIF($A$2:$A$17,A2,$C$2:$C$17)
Alternatively, use pivot tables
Life's a spreadsheet, Excel!
Say thanks, Click *
Your awesome, both ways can work! thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks