Date before another date (cell range) with SUMIFS

Hello,

I would like to have the sum of closed topics before or at the targeted closure date. I tried to use SUMIFS but I don’t know how to put those closed before the targeted closure date, because I can’t put another formula inside SUMIFS formula like this:

=SUMIFS($A2:$A7 ; $B2:$B7 ; « Closed »;$C2:$C7;"<="&$D2:$D7)

How can I make it work ? I understand I need either to use another formula or adding/substracting with other formulas but I’m not sure what and how…

Thanks for any help!

edit: I made a sample excel sheet with column and type of data I have https://docs.google.com/file/d/1RE22k-i3E-jicdi0qFujVSqgQ0mWRq7K/edit?usp=docslist_api&filetype=msexcel