# Calculating Year-to-Date totals

#### JPHenning

##### Board Regular
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?

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

#### Andrew Poulsom

##### MrExcel MVP
Try:

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

#### JPHenning

##### Board Regular
Try:

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

Great, Thank you works great.

Replies
2
Views
135
Replies
3
Views
475
Replies
1
Views
189
Replies
0
Views
966
Replies
8
Views
451

1,191,499
Messages
5,986,917
Members
440,065
Latest member
JCH136

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back