Forum Discussion

dhartkopf's avatar
dhartkopf
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's avatar
    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's avatar
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's avatar
    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"}))
  • mtarler's avatar
    mtarler
    Silver Contributor
    Mar 01, 2022

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