Formula issue - ideas?

[Camel123]

Hi,

Sheet2
Row/col A/col B
1/2017-01-01/closed
2/2016-01-01/open
3/2015-01-01/closed
4/2014-01-01/open

Sheet1
If col B in sheet 2= "open", then return value in col A= 2016-01-01, and if today's date > than this date 2016-01-01= count. In this example I have 2x open items with dates back in time, so the formula would result in= 2

Tried to play around with if, countif, count, vlookup, search & find etc. but can not get it working.

Appreciate all your guidance.

 

[Special-K99]

=SUMPRODUCT((B1:B4="open")*(TODAY()>A1:A4))
or maybe
=COUNTIFS(B1:B4,"open",A1:A4,"<"&TODAY())

 

[Camel123]

the countifs formula worked perfect of course, moments like these makes you feel tarded haha , thank you mate.