Forum Discussion
Solved
COUNTIFS help
I need to be able to count number of people who fit two criteria. One is a specific term and the other has a date entered if completed. How do I write that formula? I tried =COUNTIFS('Status Upda...
I see a small typo - can you try the formula like this?:
=COUNTIFS('Status Update'!M8:M999,">07/01/2019",'Status Update'!L8:L999, "Yes")
Sorry, I didn't refresh the page before posting.
Thank you!! That was the solution!