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?



0 Replies