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

Occasional Visitor

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

0 Replies