Calculating Year-to-Date totals

[JPHenning]

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?

 

[Andrew Poulsom]

Try:

=SUMPRODUCT(--(ISNUMBER(B$5:X$5)),--(B$5:X$5<=$D$1),B6:X6)

 

[JPHenning]

Try:

=SUMPRODUCT(--(ISNUMBER(B$5:X$5)),--(B$5:X$5<=$D$1),B6:X6)

Great, Thank you works great.