# Returning Year-to-Date Totals

#### jfpt4e

##### New Member
Hi,

What formula would I use to return the year to date total as in the following:

Cell A1 is Jan, Cell B1 is Feb, Cell C1 is Mar, and so thru L1 is Dec.
Data is in A2, B2, C2, thru L2.

So if there is a year to date total column N that depends on the month, how do I return the results depending on what month it is. For example if N1=Mar I want to say if N1 = C1, sum A2 through C2?

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Hi,

What formula would I use to return the year to date total as in the following:

Cell A1 is Jan, Cell B1 is Feb, Cell C1 is Mar, and so thru L1 is Dec.
Data is in A2, B2, C2, thru L2.

So if there is a year to date total column N that depends on the month, how do I return the results depending on what month it is. For example if N1=Mar I want to say if N1 = C1, sum A2 through C2?
Try this...

=SUM(A2:INDEX(A2:L2,MATCH(N1,A1:L1,0)))

It worked! Thank you...

Replies
10
Views
603
Replies
3
Views
161
Replies
8
Views
366
Replies
1
Views
217
Replies
2
Views
209

1,203,052
Messages
6,053,234
Members
444,648
Latest member
sinkuan85

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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