I have a complex spreadsheet with an Excel table containing my data and formula [in Excel 2010]
I have a series of columns by month. eg. Jan x, Jan y, Jan z, Jan Total, Feb x, Feb y, Feb z, Feb total, etc (thru to end of year).
I have a YTD formula that is driven by a drop-down (where I select...