YTD to update by drop down list by month

[lhoffman8386]

Hello Excel Magicians,

I am trying to get a YTD (T2:T9) cell to update per a drop-down list (B1) by month. My fiscal year goes from April - March. Please see attached for example.

And as a bonus I'd like to reference QTD per the drop down too.

Thanks for you assistance.

[nathansav]

Please Login or Register  to view this content.

Is a good place to start. this is an array formula, so you'll need to press CTRL + SHIFT + ENTER. This includes the Q's in the total, so you'll need to look at removing them

[lhoffman8386]

Wow thanks for the quick reply. I took out the Q's to clean it up. It is SUMing the entire row instead of the selected month plus prior months.