Hi all,
I've searched the forum but can't quite see what I'm after.
I have a budget file as below, and I would like the outputs in green to sum the YTD numbers. If Mar-22 is selected in A1, then I'd like columns C to E to be summed for each category. And if I change the date in A1, it will change the YTD numbers. I think it will be some sort of INDEX MATCH combo but can't quite get it to work!
Thanks in advance.
I've searched the forum but can't quite see what I'm after.
I have a budget file as below, and I would like the outputs in green to sum the YTD numbers. If Mar-22 is selected in A1, then I'd like columns C to E to be summed for each category. And if I change the date in A1, it will change the YTD numbers. I think it will be some sort of INDEX MATCH combo but can't quite get it to work!
Thanks in advance.
Mar-22 | |||||||||||||
Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | ||
Revenue | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | |
COS | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |
Costs | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | |
Revenue | 90 | ||||||||||||
COS | 30 | ||||||||||||
Costs | 45 |