YTD SUM formula using SUMIFS

[Krishna Chaitanya P]

I would like to know the formula to sum the month YTD as total and want to change as the month passed

Ex: Currently in July need data to sum up of June YTD with multiple criteria, however as soon as we enter into August, need to sum till July YTD without changing any range in formula every month, attached excel for a sample calculation colored in Yellow using SumIF but is a manually range to be increased every month which i want it to be considered automatically by using formula

 

[bosco_yip]

Try,

In R6, formula copied right to S6 and all copied down :

=SUMIF(OFFSET($C$5,,,,MATCH(TEXT(TODAY(),"mmm"),$C$4:$Q$4,0)-1),R$5,$C6)

Regards
Bosco

 

[Krishna Chaitanya P]

Beautiful, That's amazing, thanks a lot, i think it would work for my data