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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

WWDC history: Apple's product launches since 2005

Comment importer des contacts d’un iPhone à un autre iPhone ?