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!