• 513K Members
• 3,820 Online
• 611K Conversations
SOLVED

New Contributor

# 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

5 Replies
Solution

# Re: COUNTIFS 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")

# Re: COUNTIFS help

Try it like this...

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

# Re: COUNTIFS help

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

# Re: COUNTIFS help

Thank you!!! That worked!

# Re: COUNTIFS help

Thank you!! That was the solution!