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!

You did not really say what your criteria are?

From the formula, it looks like 1 of them is week no and the other is Dept? If so, try this ARRAY formula...
A2=IFERROR(INDEX('Purchase Journal'!$A:$N,SMALL(IF(('Purchase Journal'!$B$2:$B$10="week 1")*('Purchase Journal'!$A$2:$A$10=12210),ROW('Purchase Journal'!$A$2:$A$10)),ROWS($A$1:A1)),MATCH(A$1,'Purchase Journal'!$A$1:$O$1,0)),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Then copy down and across...and format...as needed

Happy to help

I am a little confused My formula creates the table that you want (per my understanding of what you asked), there is no need for a 2nd table.

Did you use CRTL SHIFT ERNTER to enter the formula, and not just ENTER? Below is your table. with my formula, copied down and across...

	A	B	C	D	E	F	G
2	11/2/2015	11/2/2015	1/1/1913	TFD	2/5/1900	1/0/1900	YES
3	11/2/2015	11/2/2015	9/6/5884	TFD	1/0/1900	1/10/1900	YES
4	11/2/2015	11/2/2015	4/23/2347	TFD	2/16/1900	1/0/1900	YES
5	11/2/2015	11/2/2015	1/10/1900	TFD	2/24/1900	1/0/1900	YES
6
7

If this is not what ypou wanted, please upload another file, showing some dummy dada and dummy outputs?