Hi guys,
How are you all?!
I am new here as a user although I have been following up many tutorials from this forum.
Current trying to build a formula where I can count a specific text in Column "A" and allocate in a different cell base if it is open or closed by year and month.
=SUMPRODUCT((MONTH($B$2:$B$1500)=E5)*(YEAR($B$2:$B$1500)=$D$5))*(A$2:A$1000="baseline")
So for example I would like to count all cells with Open and baseline criteria happened in 01/01/2019 for example.
***workbook uploaded***
Appreciate your help to crack this one, thanks in advance guys
Danz-
Bookmarks