Sum different months each month (Year to date calculation)

Hi,

Each month I need to sum the year to date (YTD) figure which each month includes the latest month, and currently I'm manually updating the formula (stretching out one column each month) but would like to automate.

I've tried SumProduct & SumIFS but can't quite get the result.

Any guidance or assistance would be greatly appreciated.

Thaks,
Greg

You can use this formula in A6:

=SUMIFS(B6:M6,$B$4:$M$4,"<="&$B$3)

This assumes that you have a date in cell B3, which represents the upper date of your range. Copy the formula down as required.

Hope this helps.

Pete

That seems to work perfectly. Thanks so much

hi there, please check attached