Hello,
-
I have created a sheet that fills financial data for my organization, this sheet is worked on daily.
-
I have to give daily, monthly, quarterly and yearly financial reports to my organization.
-
I only plan to work on the Daily Financial sheet, and have the total sum linked to other sheets.
-
It should go something like this:
If I enter that Product A made $1,000 on Day 1 in the daily sheet, the monthly sheet should update the monthly earnings for cells Product A to be $1,000. If I then enter that Product A earned $2,000 on day 2, the monthly sheet for cells product A should update to $3,000 (sum of all the days). There will be multiple products like this on the daily sheet.
The problem is that I can link the total sum of Product A to the monthly sheet, however to make a monthly sheet I would have to make 28, 30 or 31 different sheets for each day, with the monthly sheet linking to all these sheets. If I have the same sheet linked to the monthly sheet, it would change the value to whatever the sum is that day and not add the previous values to it. Going by the previous example, it would not add $1,000 and $2,000 together, it would simply replace $1,000 with $2,000.
Tl;dr A way for linked data in a different sheet to not replace older data, but add on to it (it will only be numbers).
Thank you.