Forum Discussion
Solved
Formula/Conditional Formatting to calculate months totals
Hi I have headings of all the months and some figures beneath them. At the end after December, i have a year to date total so for April i would have the sum of January to April with the heading Y...
See the attached version
It would be a lot easier--a LOT easier--to help you with this if you are able to post either a copy of the actual spreadsheet, or, if the actual contains confidential info, a mockup of it--on OneDrive or GoogleDrive, with a link pasted here that grants us access to it.
The reason for that request is that so much depends on how you've laid out your data. I (we) can make assumptions, but in order to be more helpful with your specifics it would be far more helpful to you to base any suggestions on your actual layout.
mathetes I've attached an example here, as you can see the "YTD April" is linked back to another sheet. This is because I reuse the same template for every month and just change the month and it updates across all sheets.
See the attached version
