CODEWITHSUNDEEP
google-sheets
Averett
Averett

Reputation: 66

Count if rows in range have two criteria set

I cannot find a simple answer to this, sorry if this is super obvious.

I have a table:

        A        B
1       Fruit:   Rotten?
2       Apple    TRUE
3       Banana   FALSE
4       Apple    FALSE
5       Apple    TRUE

Now I would like to have the formula for: =COUNT(of rotten Apples in range A2:B5)

Any help would be appreciated.

Upvotes: 0

Views: 19

Answers (1)

Krzysztof Krzeszewski
Krzysztof Krzeszewski

Reputation: 6714

This is pretty straight forward, you use COUNTIFS with multiple criteria

=COUNTIFS(A2:A5; "Apple"; B2:B5; TRUE)

Upvotes: 1

Related Questions