CountIf of the Data

[Abhirockie]

Actual Data is Below If I want to count Column D ( Travel to Paris Yes =4, Travel to Paris No =5).

Expected: I want to see the Data Minus Column C. ( Travel to Paris Yes =2 Should be the result)

Sl.No	Names	Travel Ban	People Who can Travel	Travel to Europe
1​	A		Yes	Yes
2​	b		Yes	Yes
3​	c		Yes	Yes
4​	d	Yes	Yes	Yes
5​	e	Yes	No	Yes
6​	f		No	Yes
7​	g		No	Yes
8​	h		No	No
9​	i		No	No

Expect Result

 

[Abhirockie]

Thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[jtakw]

You're welcome.

 

[Abhirockie]

Excepted Result = 3 Count of E Column Yes Values 7 - Total Applied only for Yes (4) Sl.No Job# Applied Part-time Job Full Time 1​ 120​ Yes Yes 2​ 130​ Yes Yes 3​ 140​ Sam Yes Yes 4​ 150​ Peter Yes Yes 5​ 160​ Yes Yes 6​ 170​ Jim Yes Yes 7​ 180​ Joe Yes Yes 8​ 190​ Yes No 9​ 120​ Joe Yes No Total 5​ Partime Jobs Total (YES) Cloumn D 9​ Full-Time Jobs Total (Yes) column E 7​

 

[jtakw]

Not sure if this is what you mean, with the limited description:

Book3.xlsx
	A	B	C	D	E
13	Sl.No	Job#	Applied	Part-time Job	Full Time
14	1	120		Yes	Yes
15	2	130		Yes	Yes
16	3	140	Sam	Yes	Yes
17	4	150	Peter	Yes	Yes
18	5	160		Yes	Yes
19	6	170	Jim	Yes	Yes
20	7	180	Joe	Yes	Yes
21	8	190		Yes	No
22	9	120	Joe	Yes	No
23	Total		5
24
25	Partime Jobs Total	9			3
26	Full-Time Jobs Total	7
Sheet725

Cell Formulas
Range	Formula
E25	E25	=COUNTIF(E14:E22,"Yes")-COUNTIFS(C14:C22,"<>",E14:E22,"Yes")

 

[Abhirockie]

You are jtakw pantomath

 

[jtakw]

Glad to help, thanks for the feedback.