Please could someone help me with a SUMPRODUCT formula? I have the following
data:
A B C
1 Window Summer Winter
2 W1 20 4
3 W2 15 1
4 W3
5 W4 8 3
6 W5 8 2
7 W6 8 1
8 W7 0 0

I need a formula that will count the number of windows with with EITHER a
summer value <10 OR a winter value <2. It should count zeros but not blank
cells.

In the above example the answer should be 5.

I hope someone can help! Thanks