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?

Thanks!

SUM(COUNTIFS) seems to return the number of cells with OR logic, and would give me 4 CELLs that meet at least 1 criteria.It's because you include column' B cells into checked range... but why? – Akina Aug 2 '18 at 4:38