Forum Discussion
Amber1023
May 11, 2023Brass Contributor
help auto sum and total sum on expanding sheet & create historical table + master and working copy
how do i calculate a sum of numbers thats i have a sheet that is a log of daily cleaning / work / how far we got / notes i need to calculate the sum of each location (some locations have more t...
JKPieterse
May 11, 2023Silver Contributor
I suggest you try to make this easy on yourself. Some suggestions:
- Try to get all your data into one single flattened table
- Make sure this table has separate columns for date, location and any other type of information you would want to get sub-total amounts grouped for
- Do not enter any formulas within that table, this is data, not your report.
With your data well structured, creating your report is as simple as inserting a pivot table using your new table of data as its source. No formulas needed whatsoever.
- Try to get all your data into one single flattened table
- Make sure this table has separate columns for date, location and any other type of information you would want to get sub-total amounts grouped for
- Do not enter any formulas within that table, this is data, not your report.
With your data well structured, creating your report is as simple as inserting a pivot table using your new table of data as its source. No formulas needed whatsoever.
- Amber1023May 11, 2023Brass Contributorwill it be a running table for the guys to insert the new info into or how do we keep it calculating daily?
- Amber1023May 11, 2023Brass Contributorthe subtotals would be for each area of the location EX: SELF is one area then theres SELF AREA 2, SELF area 3, SELF bumpout
then we have WEX as location then WEX, WEX stage 3, stafe 4, stage 5, stage 6
so i would need subtotal for all of those then a grand total of WEX, and so on for each area
i would need to be able to do the sums for the duration of the job so we can send it to them weekly as its appx a 6 month job throughtout the year
then