RE: Extracting Data from multiple sheets/rows

Hi everyone,
I've had some great success with help on the Excel Forum in the past; and I'm hopeful that I can get some again if that is ok.

The dilemma I have is that I am trying to create some Excel formulas that will in the least reduce the amount of manual Excel work people globally have to do for the business I work for. There are two trip points I have found:

1. The easier one is creating a formula that checks a) whether any text exists in a column AND b) whether this row takes place on or after 1/1/2011. I know I need to use COUNTA and COUNTIFS, but I can’t seem to get them to work together. Does anyone know how I can count the amount of rows with no text after a certain date?
2. The harder one is that I am attempting to copy data from selected columns, from one worksheet to another based on fulfilling three criteria. Is this possible, or have I simply gone too far this time? I would ask people to use filters and do it manually, however if I can get it automatically that would be fab.

Thanks everyone!

Thanks for your help; part one works beautifully thanks very much!

As for part two; I've attached a sample workbook to try to help explain what I am seeking to do.

Within the context of the example; this is what I am trying to achieve:

I am trying to filter the information based on the following criteria:

1. Must have occurred in 2011.
2. Must have no text within the column C row
3. Approval code must be '1'

I then want to copy that information that meets that criteria into another worksheet, but only columns A, E, F, J and L.

Am I overreaching?