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
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies