function to sum based on date

Originally Posted by Jondal

Looking to be able to change the date and the function will automatically sum the columns to give me the total year to date.

In the attached file I would like to change the date highlighted in blue and it will sum the columns from Jan07 to the date entered.


Any help appreciated.

Thanks
John

Try this

=SUMPRODUCT(($A$2:$N$2<=P2)*(A3:N3)) copy down

P2 contains date entered (in blue)
(adjust ranges to suite)

Originally Posted by Jondal

Great solution.

Many thanks


john

You're welcome and thank you for the feedback.