Count number of rows where the minimum of multiple columns is less than a specific number-CodePudding

I am trying to find a way to do this in Google Sheets, but couldn't really figure out the syntax - not quite sure whether I should be starting with COUNTIF, ARRAYFORMULA, or something else.

e.g.

Screenshot

How would I have a formula that would count the number of rows, if the minimum for each row between columns A-C is less than 2? In this case, the result should be 3.

CodePudding user response：

Use

CodePudding user response：

Given your sample data setup, this should work:

=COUNTA(FILTER(A:A,(A:A<2) (B:B<2) (C:C<2)))