SUM Points from Beginning of year to Today

[Robby19]

Hello,

I have a table that looks like this (It goes all the way to December);
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Employee #[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]4[/TD]
[TD]-5[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]-5[/TD]
[TD]-5[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]-5[/TD]
[TD]-5[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]-5[/TD]
[TD]-5[/TD]
[TD]0[/TD]
[/TR]
</TBODY>[/TABLE]


If the current month is Apr (based off of TODAY() or some other cell) then I need to total Jan through Apr like the above table.

I also have another table with the month, start date, and EOMONTH if that is required.
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Month[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]1-Jan-18[/TD]
[TD]31-Jan-18[/TD]
[/TR]
[TR]
[TD]Feb[/TD]
[TD]1-Feb-18[/TD]
[TD]28-Feb-18[/TD]
[/TR]
</TBODY>[/TABLE]
Etc....

Can someone help me write the Total formula?

 

[Special-K99]

If today is 2nd December 2018 what will your table look like?

Dec Jan Feb Apr etc.. Total

In which case year must be taken into account not just month.

 

[Peter_SSs]

Try this
Put =MONTH(TODAY()) in another cell, say Z1, and then use this, copied down
=SUM(B2:INDEX(B2:M2,Z1))

 

[Robby19]

In which case year must be taken into account not just month.

Thank you for the response. The excel spreadsheet will only be used for 1 calendar year. At which time I will create a copy and start fresh in 2019. Thus the months only go up to December.

 

[Robby19]

Try this
Put =MONTH(TODAY()) in another cell, say Z1, and then use this, copied down
=SUM(B2:INDEX(B2:M2,Z1))

Works great. Thank you!

 

[Peter_SSs]

Works great. Thank you!

You're welcome.