Sum year-to-date when select the month

Dear Excel Guru,

Could you please share the interactive formula that when I select a month, it will sum the year-to-date amount. Please see the attached file for details.

Thank you.

Cheers!
Dewdrop

Try this in I5:

=SUMIF(B:B,"<="&EOMONTH(H5,0),D:D)

Dear ProtonLeah and Phuoccam,

Thank you very much for your sharing.

If I added additional requirement, ie asset catagory, how to modify the formula? (please refer attached).

Thank you very much.

Cheers!
Dewdrop

Change to:

=SUMIFS($E:$E,$B:$B,"<="&EOMONTH($I5,0),$C:$C,J$4)

Dear Phuocam,

Superb, it is what I am looking for. Thank you for your sharing.

Cheers!
Dewdrop