Automate YTD Calculation

[kk111]

Hi,
I have the table below and I am trying to automate the YTD calculation.
Does anyone have a suggestion for doing this?
Thank you!!!
Kt111

[TABLE="width: 500"]
<TBODY>[TR]
[TD]Jan
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Feb
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Mar
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Qtr 1
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Apr
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]May
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Jun
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Qtr 2
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Jul
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Aug
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Sep
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Qtr 3
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Oct
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Nov
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Dec
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Qtr 4
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]YTD
[/TD]
[TD]NEED TO AUTOMATE
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[hippiehacker]

this would be a ytd for a sum =SUM(B1:INDEX(B1:B16;MATCH(TEXT(TODAY();"MMM");A1:A16;0);1))

 

[kk111]

Thank you very much for your response.
First, I needed to change all semicolons to commas.

Once I did that, I did not get the correct result. I only got "2" vs. the expected "10" (jan through oct).
Also, will this formula skip the quarters? Or, is it going to include the quarters when it sums down? I do not want to be duplicative when summing.

 

[hippiehacker]

now without the Qtr Values

=SUM(B1:INDEX(B1:B16;MATCH(TEXT(TODAY();"MMM");A1:A16;0);1))-SUMIF(A1:INDEX(B1:B16;MATCH(TEXT(TODAY();"MMM");A1:A16;0);1);"Qtr*";B1:B16)

this evaluates to 10 for me
replace the ; with commas I have dutch regional settings and have to use the ;

 

[kk111]

Perfect, thanks!!!