Forum Discussion

Copper Contributor

Feb 25, 2022

Solved

COUNTIFS Help

Recruiter here - tracking the status of the jobs currently being recruited on. I want to count all of the jobs for a company in a certain status. I checked for spaces and spelling - so I can't...

excel

dhartkopf
May 02, 2022
Found my solve = =SUM(COUNTIFS(Danielle!A:A, "IP Corporate", Danielle!M:M, {"Manager Interview","Screening","Resume Intake/Review","Sourcing"}))

dhartkopf

Copper Contributor

Mar 01, 2022

I have =COUNTIFS(Danielle!A:A,"IP Corporate",Danielle!M:M,"Resume Intake/Review") + COUNTIFS(Danielle!A:A,"IP Corporate",Danielle!M:M,"Manager Interview") + COUNTIFS(Danielle!A:A,"IP Corporate",Danielle!M:M,"Resume Intake/Review") + COUNTIFS(Danielle!A:A,"IP Corporate",Danielle!M:M,"Screening"), but I was just hoping to not have so many COUNTIFS to avoid errors.

Thanks all for the input

JMB17

Bronze Contributor

Mar 01, 2022

You could also try:
=SUMPRODUCT((Danielle!A:A="IP Corporate")*(Danielle!M:M={"Resume Intake/Review","Manager Interview","Screening"}))