COUNTIF fuction?

[Dishboy09]

Looking for some assistance on a COUNTIF function to auto sort some data. I made a quick and simple version of what im looking to do below. The top table is the whole set of data. I want it to only display the data for certain employees, and certain employees results.

What would the full function be to display only the bottom table data without using filters.

Thank You

Employee​	Passing​	Type​
Bob​	1​	a
Bob​	1​	a
Tommy​	1​	a
Tim​	1​	b
Susan​	0​	b
Susan​	0​	a
Eric​	1​	a
Team Member​	Passing​	Type​
Bob​	1​	a
Bob​	1​	a
Susan​	0​	b
Susan​	0​	a
End Result​
Susan​	0​	b
Susan​	0​	a

 

[earthworm]

Please share the result that you want to be displayed

 

[Dishboy09]

Please share the result that you want to be displayed

The bottom portion that says End Result is what i am looking to be displayed.

 

[earthworm]

I have developed more than you required . Because in my view this was the only way

You can view the excel Here

 

[Fluff]

@earthworm
Please post your solution to the board, rather than just supplying a link to a file. As per the rules.