How to do an Auto YTD SUM based on a month i select in a drop down box?

So if i was to change the dropdown box from June to July, it will automatically calculate the sum upto and including July figures...

Thanks

Capture.PNG

So as you can see from the img, the YTD is a simple =SUM function to get total YTD units for Feb-May

I want to be able to change the month in the dropdown box and the YTD sum to auto calc the YTD figure. So if i was to change the dropdown box to July, it will auto sum Feb-Jul

Hope this makes it more clear.

thank you

Are the dates date format or text?

Assuming dates (months) are text

in P4

=SUM(OFFSET($C$4,0,0,1,MATCH($B$1,$C$3:$N$3,0)))

Thanks John, just what i was after!!

Appreciate the help guys!

Thanks for the feedback and rep.

Could please mark thread as solved ("Thread Tools" at top of first post)