Sum Rest of Year Formula based on Month

[lindz5970]

I need to a ROY sum based on a month number input criteria. I set up my YTD already:
=SUM(A2:INDEX(A2:L2,7)) with 7 meaning July.

However I then need another formula to calculate August-December ROY. My YTD formula is counting down from the top, its almost like I need to count up from the bottom....

And I can not just do the FY minus YTD b/c data is coming from 2 different columns, which is why I need to do the ROY formula separate.

 

[Tetra201]

Maybe

=SUM(INDEX(A2:L2,8):L2) with 8 meaning August.

 

[lindz5970]

Maybe

=SUM(INDEX(A2:L2,8):L2) with 8 meaning August.

That worked!!!! that you so much!!