Is it possible to count the number of rows in a worksheet that meet at least one criteria?
For example, given the following table,
A B C D 1 Vehicle 1 wheel 2 wheels 4 wheels 2 Unicycle Y N N 3 Bicycle N Y Y 4 Motorbike N Y N 5 Car N N Y
I wish to get the number of vehicles that have either 2 OR 4 wheels. The answer would be 3 in this case.
SUM(COUNTIFS) seems to return the number of cells with OR logic, and would give me 4 CELLs that meet at least 1 criteria. SUMPRODUCT() seems to return the number of rows with AND logic, and would give me 1 row that meets BOTH criteria. How do I get a formula that returns the number of ROWS that meet AT LEAST ONE criteria?