Formular for YTD results

[moe32]

Hi all,

Please find attached.

I'm looking for a formula that will give me YTD (year-to-date) totals depending on what month I state.

Hopefully the attached will be clear but what im looking for. Ideally im trying to avoid a second set of data for YTD totals and then use an index match formula (issue with this is in the actual file i'll be using the files are so big duplicating the data just to get the YTD numbers iss to inefficient, it would be easier for me to every month just update a sum formula)

[Bo_Ry]

Please try at T4
=SUMIFS(D4:O4,$D$2:$O$2,"<="&T$3)

[moe32]

perfect!

many thanks!