Countif from a column but excluding data from other column

[leyagaco]

Hello,

I'm trying to count all the things from my column G but excluding "Workday" from my Column E. I already have this formula:

=SUM(COUNTIFS(Candidates!$G:$G,{"Screen","Pipeline","Not Eligible for Rehire","Duplicate","No Match/Min. Or Preferred Qualifications","No Match/Salary","No Match/Shift or Schedule","No Match/Location","Internal process","Contacted","No Answer","Withdrew"}))

How do I add to it to exclude from counting everything that came from "Workday" in Column E.

I'm attaching an image.

Hope you can help!

 

[Toadstool]

Hi Leyagaco,

You could add a COUNTIFS criteria to exclude Workday in column E.

Leyagaco.xlsx
	C	D	E	F	G
1	Result		Source	Position	Review Status
2	7		Workday	Mgr1	Screen
3			Workday	Mg2	Pipeline
4			Workday	Mgr1	Not Eligible for Rehire
5			Workday	Mg2	Duplicate
6			Workday	Mgr1	No Match/Min. Or Preferred Qualifications
7			Website	Mg2	No Match/Salary
8			Website	Mgr1	No Match/Shift or Schedule
9			Website	Mg2	No Match/Location
10			Website	Mgr1	Internal process
11			Website	Mg2	Contacted
12			Website	Mgr1	No Answer
13			Website	Mg2	Withdrew
14			Website	Mgr1	TheLastOne Not Counted
Candidates

Cell Formulas
Range	Formula
C2	C2	=SUM(COUNTIFS(Candidates!$G:$G,{"Screen","Pipeline","Not Eligible for Rehire","Duplicate","No Match/Min. Or Preferred Qualifications","No Match/Salary","No Match/Shift or Schedule","No Match/Location","Internal process","Contacted","No Answer","Withdrew"},$E:$E,"<>Workday"))

 

[6StringJazzer]

You seem to be listing all possible values for column G and counting and summing them. I'm not sure why you are doing that. You could just count all non-blanks.

=COUNTIFS(Candidates!$G:$G,"<>",Candidates!$E:$E,"<>Workday")-1

You subtract 1 to account for the header row.

 

[leyagaco]

Hi Leyagaco,

You could add a COUNTIFS criteria to exclude Workday in column E.

It worked, thank you so much!

 

[leyagaco]

You seem to be listing all possible values for column G and counting and summing them. I'm not sure why you are doing that. You could just count all non-blanks.

=COUNTIFS(Candidates!$G:$G,"<>",Candidates!$E:$E,"<>Workday")-1

You subtract 1 to account for the header row.

It is easier this way and it worked, thank you!