Forum Discussion
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...
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.
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
worked it out. thanks
Hi Kamila,
Just drag last 2 items to right side box as show in screenshot.
