sorting and sub totaling columns

[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?

 

[Pete_UK]

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

Hope this helps.

Pete

 

[Pete_UK]

Mind you, you should have a header row immediately above your data.

Pete