IF, AND, COUNTIF Functions

Hello-

I'm trying to set up a print sheet that will return the information that matches two criteria and display it without the blank lines from data that doesn't match the criteria. I found a formula I think would work if I could just figure out how to nest the AND function correctly. See the Panda picture comment for the example I used here: http://www.excelforum.com/excel-work...-function.html.

I've attached my example data and attempts at a print page here: PJ Example for Testing print page.xlsx. Included are both my original IF with nested AND function which returned the correct data with blank lines, and my attempt at the more complex COUNTIF function from the example attached above.

If someone could help me figure out what's going wrong with my formula, I'd appreciate it!