Feb 25 2022 07:59 AM
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 figure out what to do.
=countifs(Danielle!A:A, "Interplastic", Danielle!M:M, "Resume Intake/Review","Screening","Manager Interview","Sourcing","Agency Search").
I know it can be done - HELP!
Feb 25 2022 08:09 AM - edited Feb 25 2022 08:15 AM
=countifs(Danielle!A:A, "Interplastic", Danielle!M:M, "Resume Intake/Review", Danielle!O:O, "Screening", Danielle!P:P, "Manager Interview", Danielle!Z:Z, "Sourcing", Danielle!T:T, "Agency Search")
Does it work if you add criteria ranges for the other criteria ( "Screening","Manager Interview","Sourcing","Agency Search" ) ?
EDIT:
=SUMPRODUCT((Danielle!A:A= "Interplastic")*(( Danielle!M:M= "Resume Intake/Review")+(Danielle!M:M="Screening")+(Danielle!M:M="Manager Interview")+(Danielle!M:M="Sourcing")+(Danielle!M:M="Agency Search")))
Maybe you want Screening or Manager Interview or Sourcing or Agency Search in range Danielle!M:M.
Feb 25 2022 08:16 AM
Mar 01 2022 10:51 AM
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
Mar 01 2022 12:34 PM - edited Mar 01 2022 12:36 PM
I think you have a repeat in that list. but I think using that chain of countifs may actually be quicker than using the sumproduct. That said, did the sumproduct not work?
=SUMRPODUCT( (Danielle!A:A="IP Corporate") * (
(Danielle!M:M="Resume Intake/Review") + (Danielle!M:M="Manager Interview") + (Danielle!M:M="Screening") )
Mar 01 2022 01:12 PM
May 02 2022 09:45 AM
SolutionFound my solve = =SUM(COUNTIFS(Danielle!A:A, "IP Corporate", Danielle!M:M, {"Manager Interview","Screening","Resume Intake/Review","Sourcing"}))
May 02 2022 09:45 AM
SolutionFound my solve = =SUM(COUNTIFS(Danielle!A:A, "IP Corporate", Danielle!M:M, {"Manager Interview","Screening","Resume Intake/Review","Sourcing"}))