If, then addition

[dfb]

I have account numbers listed in column A. I want to total
the amounts in column B for each account number. Example:
Column A Column B
100 50.00
200 150.00
200 75.00

I want the formula to get totals of 100=50.00 and
200=225.00.

Also, I want to put these totals on another sheet in the
workbook. Do I have to have them totaled on the first
sheet & copy & paste to the next sheet or is there a way
to add them to sheet 2 without totaling them on sheet 1?

 

[Bernie Deitrick]

dfb,

Use a pivot table - Select one cell in your table, or the entire table, then use Data | PivotTable....

HTH,
Bernie
Excel MVP