I am trying to do an AND between 2 conditions which work with a count.I want a result of something as pasted below
(COUNTIFS(F33:F83,"<12/14/2015",F33:F83,">12/11/2015") and (COUNTIFS(G3:G53,"\Release 2\Sprint 2")))
So the first count is anything between the 2 dates and the next is the count of anything which matches "\Release 2\Sprint 2"
I tried SUMPRODUCT but not able to get it right.
=SUMPRODUCT(--(F33:F83="<12/14/2015",F33:F83=">12/11/2015"),--(G3:G53="\Release 2\Sprint 2")))
And I definitely know that this is not doing an AND operation but I tried nevertheless
=SUM(COUNTIFS(F33:F83,"<12/28/2015",F33:F83,">12/25/2015")+(COUNTIFS(G3:G53,"\Release 2\Sprint 3")))
Help would be really appreciated
Bookmarks