COUNTIFS help

[afy54]

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

[#2 · Accepted solution]

@afy54 

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")

[#3]

@afy54 

Try it like this...

=COUNTIFS('Status Update'!M8:M999,">07/01/2019", 'Status Update'!L8:L999, "Yes")

[#4]

@Procrastophile 

Sorry, I didn't refresh the page before posting.

[#5]

Thank you!!! That worked!

[#6]

Thank you!! That was the solution!