Forum Discussion
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 Update'!M8:M999,">07/01/2019", 'Status Update'!L:'Status Update'!L8:L999, "Yes")
With the M column having dates entered and the L column having Yes or No entered. I want to have the number of people who were spoken to (so the date was entered) and those who said Yes.
HELP
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")
5 Replies
Try it like this...
=COUNTIFS('Status Update'!M8:M999,">07/01/2019", 'Status Update'!L8:L999, "Yes")
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")
- Thank you!!! That worked!
Sorry, I didn't refresh the page before posting.
- Thank you!! That was the solution!
