Addition based on account

[sbakewell1101]

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?

[JeanRage]

Hi,

Take a look at the Sumif() function ... press F1 for help and example ...

HTH

[royUK]

maybe a PivotTable

http://excel-it.com/clear_code.htm