Forum Discussion

afy54's avatar
afy54
Copper Contributor
Sep 10, 2019
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...
excel
Formulas and Functions
  • Procrastophile's avatar
    Procrastophile
    Sep 10, 2019

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

Procrastophile's avatar
Procrastophile
Copper Contributor
Sep 10, 2019

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

afy54's avatar
afy54
Copper Contributor
Sep 10, 2019
Thank you!!! That worked!

Resources