Hi all.
I’d really appreciate a little bit of help if possible, please, as I'm stuck!
See my example spreadsheet attached.
I’m doing a yearly product sales forecast where for each month of the year I have a budget set and then an actual total achieved.
I’d like to populate the small simple table cells on row 28 so that I can create a chart, but for each month state if it should calculate the budget total or the actual Toal (both shown in row 27 against each month) - I hope that make sense.
So you can see April to November I’d like to use Actual totals, but for December to March use the Budget totals.
Is there a way to do this please?
I then have a second question - is it possible that the cells in row 27 automatically change based on the month we’re in. So November and all before will show Actual, but December onwards will show Budget. When 1st December then starts, the cell for December changes from Budget to Actual.
Many thanks, really appreciate the help.
Bookmarks