How to use formula to select those cases that meet some criteria?

Hi, I need to select cases in my file which satisfy some criteria. It is attached here.

Basically, I am only interested in these cases which:

1) date within year 2012,
2) there is some figure for sales, profit or growth (i.e. not all fields are error).

I don't want to manually do this as there are so many cases like this. So some Excel formulae will be preferred.

Can you please have a look?