Help on Excel Please

  henbroon6 21:07 15 Jan 2010

In column A I have 5000 product codes a lot of which are duplicates. In the adjoining cell in column B are sales figures for each of the codes. I need to get the totals of all the sales by product. Can someone tell me if there is a formula to do this please.

  FRANKMAC 21:33 15 Jan 2010

You dont say which version you are using, but i use Offcie 2007. And this is how i would do it.
1. Goto the data tab. Highlight the two coloumns including the titles and then sort A to Z. Choosing column A title as what to sort by.
2.With the same items highlighted go to Group,and this will make a group of the whole 2 columns.
3. with the same group highlighted, click SubTotal, and select the tickbox (it will probbaly do this by default) for what ever your column b has been called.

It maybe different on Excel 2003, but the same things would be available from the normal menus.


  henbroon6 22:15 15 Jan 2010

Thank you Frankmac, it worked a treat.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei MateBook X Pro review: Hands-on

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?