Year To Date Formula

[JasonMcQueen]

Is there a simple formula for calculating a shifting YTD point?

I have a data table where by A3:A14 is my date range (month) and B3:14) is my data. I also have a drop down box in A18 (months) which allows the user to choose a month to select the YTD figure up to. So, for example, if we're in June and the user uses the drop down to select May I need the WTD to reflect the YTD figures as it was in May etc.

[cbatrody]

Hi,

Yes, there is. Please post a sample template of your workbook using "Go Advanced" option below.

[Tony Valko]

Maybe this...

Data Range

	A	B
3	Jan	58
4	Feb	52
5	Mar	62
6	Apr	7
7	May	73
8	Jun	4
9	Jul	22
10	Aug	11
11	Sep	80
12	Oct	59
13	Nov	73
14	Dec	31
15	------	------
16
17
18	May	252

This formula entered in B18:

=SUM(B3:INDEX(B3:B14,MATCH(A18,A3:A14,0)))

[JasonMcQueen]

Thanks, that works!

[Tony Valko]

You're welcome. Thanks for the feedback!