Forum Discussion

kamjam's avatar
kamjam
Copper Contributor
Apr 18, 2018
Solved

excel help needed

Hi. Wonder if someone can help.  I have a spreadsheet with hundreds on stores. Each store has few rows with costs, is there any formula i could use to to add up all cost for each store so i only hav...
Formulas & Functions
training
  • Logaraj Sekar's avatar
    Logaraj Sekar
    Apr 18, 2018

    Hi Kamila,

     

    1. Select entire Column I to AA.

    2. Insert - > Pivot Table -> Choose where you want it in existing / new sheet -> Then Click OK.

    3. In Pivot Table Field List (which is now appear on right side), Select 'Store Code' and 'Amount' (column you want to sum). 

    4. Refer Screenshot.

     

    Ask clarification, if any.

     

Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
Apr 18, 2018

Hi Kamila,

 

1. Select entire Column I to AA.

2. Insert - > Pivot Table -> Choose where you want it in existing / new sheet -> Then Click OK.

3. In Pivot Table Field List (which is now appear on right side), Select 'Store Code' and 'Amount' (column you want to sum). 

4. Refer Screenshot.

 

Ask clarification, if any.

 

  • kamjam's avatar
    kamjam
    Copper Contributor
    Apr 18, 2018

    thank you . that would make my life easier , but having trouble with the pivot table, why is not adding up the store codes .looks different than your pivot table. see attachment 

    • kamjam's avatar
      kamjam
      Copper Contributor
      Apr 18, 2018
      worked it out. thanks
      • Logaraj Sekar's avatar
        Logaraj Sekar
        Iron Contributor
        Apr 18, 2018

        Hi Kamila,

         

        Just drag last 2 items to right side box as show in screenshot.

Resources