Excel - Sum cells based on a range of values in a column in a date interval

Hi all!

I'm having a brekdown over a problem that can't be unsolveable ;)

I want to:

Sum Sheet2.C:C
if Sheet2.A:A between Sheet1.B3 and Sheet1.B4 (this is dates)
and Sheet2.B:B is existing in Sheet3.A2:A53 (this is text)

Does anyone have a tip?

//Ann-Sofie