Formula to Sum the MTD score

[Balajisx]

Hi Team,

I have budget and Invoice amount month on month. I want to create a dynamic formula in C15 if I add any values for May month invoice it should sum only till may in budget. Like wise if I add any data for June month invoice the budget MTD should sum till June. Please help me on this.

Attached is the sample file for your reference.

Thanks in advance.
Regards,
Balajisx

 

[AliGW]

Try this:

=SUMIF($B$2:$B$13,"<>0",$C$2:$C$13)

 

[bosco_yip]

MTD sum,

In C15, formula copy across to D15 :

=SUM(C2:INDEX(C2:C13,INDEX(MATCH(2,1/($B$2:$B$13>0)),0)))

Regards
Bosco

 

[Balajisx]

Thank you!! Both works fine

 

[AliGW]

You're welcome!

 

[Balajisx]

I have also tried with offset function and this too works fine. I hope this will help others who have similar question.

here is the formula

=SUM(OFFSET($C$1,1,0,MONTH(TODAY()),1))

regards,
Balajisx