Hi,
I am having difficaulties calculating YTD totals in a work book,
I have a workbook that has a budget sheet on it for sales in one column then the % of sale next to it for each month. at the end of the sheet I have the sum for the year total next to the year total I want to create a YTD total depending on what month I have specified in cell D1.
Below is the start of my sheet however this goes along to Dec-09 and then year total and the YTD cell at the end.<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...NGE] Can anyone suggets away of doing this?
I am having difficaulties calculating YTD totals in a work book,
I have a workbook that has a budget sheet on it for sales in one column then the % of sale next to it for each month. at the end of the sheet I have the sum for the year total next to the year total I want to create a YTD total depending on what month I have specified in cell D1.
Below is the start of my sheet however this goes along to Dec-09 and then year total and the YTD cell at the end.<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...NGE] Can anyone suggets away of doing this?