Excel count in array with multiple criteria

Question

I believe that I need an array formula in order to accomplish this task, but I'm not entirely sure.

I need to count the number of records which match 'Cadmium' and are greater than a particular value (0.0005).

Here's an example of how my data is arranged. The real dataset contains thousands more species and rows.

Start cell A1:

Cadmium      0.0005
Chromium     0.0100
Copper       0.0010
Cadmium      0.0010
Nickel       0.3
Cadmium      0.0010

Thus the formula would be able to filter out cadmium, and those results greater than 0.0005 (i.e. two).

Scott Craner · Accepted Answer · 2016-01-28 15:18:54Z

1

=COUNTIFS(A:A,"Cadmium",B:B,">.0005")

answered Jan 28, 2016 at 15:18

Scott Craner

154k10 gold badges52 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1