COUNTIFS giving #Incorrect Argument Set
Hi,
I'm trying to create a data set that counts the number of deliverables due within a week of the year.
What I could like to do is to count the number of items checked in the "deliverables" box, that falls before/within a week ending finish date. The sheet I'm doing this in looks like this:
The formular I am using is: =COUNTIFS({Design Schedule Range 4}, =1, {Design Schedule Range 1}, <(Date@row + 1))
Where "Design Schedule Range 4" is the column titled "Deliverable" in the first screenshot and "Design Schedule Range 1" is the "Finish" column in the same screenshot. Any tips/ideas? I am able to do the arguments separately but it's seems to be when I put them together that I have issues.
Answers
-
If the formula works when the criterion are separated but not when combined it might be due to differences in the ranges you selected. Can you check that Design Schedule Range 4 and Design Schedule Range 1 refer to the same size and shape of cells (ideally one full column in each)?
Help Article Resources
Categories
Check out the Formula Handbook template!