SOLVED
Home

COUNTIFS help

%3CLINGO-SUB%20id%3D%22lingo-sub-846987%22%20slang%3D%22en-US%22%3ECOUNTIFS%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846987%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20be%20able%20to%20count%20number%20of%20people%20who%20fit%20two%20criteria.%20One%20is%20a%20specific%20term%20and%20the%20other%20has%20a%20date%20entered%20if%20completed.%20How%20do%20I%20write%20that%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%26nbsp%3B%3CSPAN%3E%3DCOUNTIFS('Status%20Update'!M8%3AM999%2C%22%26gt%3B07%2F01%2F2019%22%2C%20'Status%20Update'!L%3A'Status%20Update'!L8%3AL999%2C%20%22Yes%22)%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWith%20the%20M%20column%20having%20dates%20entered%20and%20the%20L%20column%20having%20Yes%20or%20No%20entered.%20I%20want%20to%20have%20the%20number%20of%20people%20who%20were%20spoken%20to%20(so%20the%20date%20was%20entered)%20and%20those%20who%20said%20Yes.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHELP%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-846987%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847076%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIFS%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847076%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406659%22%20target%3D%22_blank%22%3E%40afy54%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20a%20small%20typo%20-%20can%20you%20try%20the%20formula%20like%20this%3F%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DCOUNTIFS('Status%20Update'!M8%3AM999%2C%22%26gt%3B07%2F01%2F2019%22%2C'Status%20Update'!L8%3AL999%2C%20%22Yes%22)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847077%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIFS%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406659%22%20target%3D%22_blank%22%3E%40afy54%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20it%20like%20this...%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DCOUNTIFS('Status%20Update'!M8%3AM999%2C%22%26gt%3B07%2F01%2F2019%22%2C%20'Status%20Update'!L8%3AL999%2C%20%22Yes%22)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847079%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIFS%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847079%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406660%22%20target%3D%22_blank%22%3E%40Procrastophile%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%2C%20I%20didn't%20refresh%20the%20page%20before%20posting.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847080%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIFS%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847080%22%20slang%3D%22en-US%22%3EThank%20you!!!%20That%20worked!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847081%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIFS%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847081%22%20slang%3D%22en-US%22%3EThank%20you!!%20That%20was%20the%20solution!%3C%2FLINGO-BODY%3E
afy54
New Contributor

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

@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 

Try it like this...

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

@Procrastophile 

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

Thank you!!! That worked!
Thank you!! That was the solution!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies