Forum Discussion
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...
Found my solve = =SUM(COUNTIFS(Danielle!A:A, "IP Corporate", Danielle!M:M, {"Manager Interview","Screening","Resume Intake/Review","Sourcing"}))
this formula isn't right (but obviously you realize that):
=countifs( Danielle!A:A, "Interplastic",
Danielle!M:M, "Resume Intake/Review",
"Screening","Manager Interview",
"Sourcing","Agency Search")
notice how I grouped pairs because COUNTIFS wants to check all the arrays in the first item of those pairs to see if corresponding items match the criteria in the second item of the pair. But the last couple pairs don't even have an array to do a lookup on.
a more flexible way is to use SUMPRODUCT()
=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") ) )
so in this case you get a TRUE or FALSE in each case and by using + it acts like an OR and then using a * it acts like an AND.
=countifs( Danielle!A:A, "Interplastic",
Danielle!M:M, "Resume Intake/Review",
"Screening","Manager Interview",
"Sourcing","Agency Search")
notice how I grouped pairs because COUNTIFS wants to check all the arrays in the first item of those pairs to see if corresponding items match the criteria in the second item of the pair. But the last couple pairs don't even have an array to do a lookup on.
a more flexible way is to use SUMPRODUCT()
=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") ) )
so in this case you get a TRUE or FALSE in each case and by using + it acts like an OR and then using a * it acts like an AND.