Count with criteria

[B7Des]

I need to count how many values from the last 5 value (based on criteria) complies on on e criteria based on some criteria.

I have attached on exemple

Thanks,




Off topic:

When i access this forum (www.excelforum.com) i have this message:

The site ahead contains malware

Attackers currently on www.excelforum.com might attempt to install dangerous programs on your computer that steal or delete your information (for example, photos, passwords, messages, and credit cards).

Automatically report details of possible security incidents to Google. Privacy policy

I use Chrome

[LJMetzger]

Hi B7Des,

I think AutoFilter may solve your problem with very little effort. I was able to get the results you wanted in les than 30 seconds.

For an AutoFilter tutorial see: http://www.wikihow.com/Use-AutoFilter-in-MS-Excel

Lewis

[B7Des]

Thank's LJMetzger,

I need a formula.

I have found this and it's work for my purpose


countif(IF(ROW(F7:F25)>=LARGE(IF((B7:B25=B3)*(C7:C25=C3),ROW(F7:F25)),5),IF((B7:B25=B3)*(C7:C25=C3),F7:F25)),D3)