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

OliverScheurich

Gold Contributor

Feb 25, 2022

dhartkopf

=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.