sorting and sub totaling columns

D

dmills

I have several columns of data and need to sub total my spreadsheet
Example
Column A - ELX-1111, Column B = 50
Column A - ELX-1111, Column B = 45
Column A - ELX-5555, Column B - 33
How can I sub total column B based on the change in data in column A?
 
P

Pete_UK

Use Data | Subtotals - it's designed for exactly this, as long as
column A is sorted.

Hope this helps.

Pete
 
Top