Using COUNTIFS for multiple criteria
I wanted to count the number of TASKS that have a STATUS <> Complete where the FINISH date is <= TODAY and I have that formula:
=COUNTIFS(Status:Status, <>"Complete", Finish:Finish, <=TODAY())
Now I want to add Assigned To into this equation. So I want to count the number of TASKS that have a STATUS <> Complete where the FINISH date is <= TODAY … and ASSIGNED TO = “Lindsey Crabtree”
I am having trouble getting this formula to work. I want to do this for each person on the team, there are about 10 people. I am putting this information into a sheet so that I can display it on the dashboard.
Further, once I have this formula figured out, I will need to use another reference sheet to pull the data but I was trying to get it to work first as simply as possible.
Thank you in advance for any help you can give me!
Help Article Resources
Check out the Formula Handbook template!