Sum data in column for dates until today

Hey Guys,

PLEASE, PLEASE, PLEASE HELP

File attached!

I'm working on a worksheet (Sales Report) where row 1 contain all the momths of this year (October in A1, November in B1, etc) and row 2 contains values that I want to summate. (The reason why the first month is October is beacause our fiscal years starts in October 2017 and ends September 2018)

However, I only want to automatically summate the values in column B from january till today. The values in the other cells of column B (corresponding to dates later in the year) should not be summated (yet).

So the summation should change automatically monthly (because in each new month that current month should now be included in the summation).

Does anybody know how I can achieve this?

Thanks a lot!

Dear benishiryo

Thanks a lot my friend!! Is there any chance you could insert both options in the file I attached?

Originally Posted by benishiryo

welcome to the forum, my fellow Singaporean. 2 ways you can try:
=SUM(A2:INDEX(A2:L2,MATCH(TEXT(TODAY(),"mmmm"),$A$1:$L$1,0)))

my preferred method would be to change the dates in row 1. type 1oct17 for cell A1. do the same for the rest; 1nov17, 1dec17, etc. select the dates and right-click -> FOrmat Cells -> Custom:
mmmm

you now have accurate dates and presented in the way you want it. then:
=SUMIF($A$1:$L$1,"<="&EOMONTH(TODAY(),0),A2:L2)

Hey Benishiryo,

I managed to change the dates and format the cells so it is presented in the right way. Then, when I try to insert your formula, it doesn't work. Excel tells me that it isn't a formula although it starts with '='.... Please help me, I am stuck.

Thanks guys!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.