Addition based on account
If column A is my accounts column say account 221 and account 222 and column b has my dollar amounts for each account how can I get it to add the dollar amounts for each account together? so i have one total for account 221 and one total for 222?
Hi,
Take a look at the Sumif() function ... press F1 for help and example ...
HTH
maybe a PivotTable
http://excel-it.com/clear_code.htm
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks