Forum Discussion
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 have one row for each store . don't want to do sum formula for each store as there is hundreds of them
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.
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.
