Here is the Function I have written, which is telling me that my CountIf requires 2 Arguments:
=SUMPRODUCT(Sourcing!$H:$H<=DATE(2018,1,31))*(Countif(Sourcing!J:J,"Active"))+(Countif(Sourcing!J:J,"Considered"))*(Countif((Sourcing!$H:$H>=DATE(2018,1,1))))
I am trying to count a number of products within the Active and Considered categories during the month of January. I feel like I am very close, I just can't complete it. Can someone please assist?
=SUMPRODUCT(Sourcing!$H:$H<=DATE(2018,1,31))*(Countif(Sourcing!J:J,"Active"))+(Countif(Sourcing!J:J,"Considered"))*(Countif((Sourcing!$H:$H>=DATE(2018,1,1))))
I am trying to count a number of products within the Active and Considered categories during the month of January. I feel like I am very close, I just can't complete it. Can someone please assist?