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]

Column C= Travel to Paris / People Who can Travel

 

[Fluff]

With that data shouldn't the answer be 3 & not 2?

 

[Abhirockie]

I need to see the actual result 2...

Actual count of people who want to travel (yes =4) Minus count of ban .(2). ..

 

[jtakw]

Hi,

I have the same question as Fluff.
The people who are "ban" are d & e in the Name column, a, b, & c are Not "ban", but wants to travel?

 

[Abhirockie]

Need the count of column D - count of column C

 

[Fluff]

But there are 4 people who can travel & only one of them has a travel ban?

 

[Abhirockie]

I need the result of Count of coumn D - Count of Column C

Sl.No	Names	Restriction	Travel Paris	Travel to Europe
1​	A		Yes	Yes
2​	b		Yes	Yes
3​	c	Yes	Yes	Yes
4​	d	Yes	Yes	Yes

 

[Fluff]

That is not the same as the data you posted originally.
How about

=COUNTIFS(D:D,"Yes",C:C,"<>Yes")

 

[jtakw]

I need the result of Count of coumn D - Count of Column C

Sl.No	Names	Restriction	Travel Paris	Travel to Europe
1​	A		Yes	Yes
2​	b		Yes	Yes
3​	c	Yes	Yes	Yes
4​	d	Yes	Yes	Yes

If you insist:

Book3.xlsx
	A	B	C	D	E	F	G	H
1	Sl.No	Names	Travel Ban	People Who can Travel	Travel to Europe		What you want	Maybe?
2	1	A		Yes	Yes		2	3
3	2	b		Yes	Yes
4	3	c		Yes	Yes
5	4	d	Yes	Yes	Yes
6	5	e	Yes	No	Yes
7	6	f		No	Yes
8	7	g		No	Yes
9	8	h		No	No
10	9	i		No	No
Sheet725

Cell Formulas
Range	Formula
G2	G2	=COUNTIF(D2:D10,"Yes")-COUNTIF(C2:C10,"Yes")
H2	H2	=COUNTIFS(D2:D10,"Yes",C2:C10,"<>Yes")