Can someone please help me with this formula?
SUMPRODUCT((MONTH(Issues_Closed_On)=1)*YEAR((Issues_Closed_On)=2008)*(Issue _Status="Active")*(Job_Assigned_To="Charlie"))
I have 3-columns and Named ranges, namely, Issues_Closed_On, Issue_Status and Job_Assigned_To. Issues_Closed_On has list of dates.
I need to find the no. of "Active" in the month of January where the Job_Assigned_To was "Charlile". I am getting value error in my formula.
Thanks.