Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, February 15, 2018
  0 Replies
  3.2K Visits
0
Votes
Undo
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?
There are no replies made for this post yet.