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
In the heading for the YTD column, enter the formula
="YTD "&TEXT(TODAY(), "mmmm")
Let's say your month headings are in B1 (January) to M1 (December)
In the YTD cell for row 2, enter the formula
=SUM(B2:INDEX(B2:M2, MONTH(TODAY())))
Fill down.
That works thanks, I've attached an example so you could see if this was still possible with a slight adjustment. The YTD heading in M2 will need to be linked to a summary cover page. Thanks
Sorry, I hadn't noticed that you replied while I was composing a reply.
- Perfect, many thanks
