Help! COUNTIFS function with 3 criteria
Hi! I'm having trouble getting this COUNTIFS function to work, getting the error "incorrect argument set".
What I have: =COUNTIFS([Due Date]20:[Due Date]3443, <=TODAY(-7), [Assigned To]17:[Assigned To]3440, <>"", [Task Completed On Time?]16:[Task Completed On Time?]3440, "Yes")
What I want it to do: Count rows that meet 3 criteria: Due Date is within the last 7 days, have any value in the Assigned To column, and say "yes" in my Tasks Completed On Time column.
Any idea where I'm going wrong? I have a separate, similar formula that works fine, which is: =COUNTIFS([Due Date]20:[Due Date]3443, <=TODAY(-7), [Assigned To]17:[Assigned To]3440, <>""). Basically, I'm trying to add on a 3rd criteria to this one.
Thanks for any help!
Help Article Resources
Check out the Formula Handbook template!