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?

What do you mean when you say you want to 'select' them - do you literally want Excel to select the rows that contain those companies?

Originally Posted by Andrew-R

What do you mean when you say you want to 'select' them - do you literally want Excel to select the rows that contain those companies?

Hi Andrew, when I said 'select', it means I want to pick up all those cases which satisfy the criteria given.

Originally Posted by DonkeyOte

One possibility:

Formula:

Please Login or Register  to view this content.

You could also combine some COUNTIFS (given .xlsx).

To simplify I would suggest storing a COUNT on each row - eg =COUNT(C2:E2) and then use that column in subsequent calculation.

Hi, many thanks for the formula which shows the total number of cases which satisfy the criteria. But my question is: HOW TO identify these individual cases and save them? Sorry for this further question as I'm pretty new to Excel.

Originally Posted by Marcol

Maybe use C/F on your range
Condition 1
Formula is

Please Login or Register  to view this content.

Where H2 is the required year, change this to test.
Then in , say J2, adjust Dons' formula to read H2.

Hi Marcol, your formulae really worked! Thanks for your help