Forum Discussion
Formula/Conditional Formatting to calculate months totals
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