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