Count values with multiple criteria

[Wirral Wizard]

I'd be really grateful if someone could help me with a formula on the attached spreadsheet example. The explanation of what I'm looking to do is in the spreadsheet.

Cheers.

WW

[shg]

=SUMPRODUCT( SIGN((D1:D7<11) + (K1:K7<11)) * (A1:A7+C1:C7 > 2))

Please ask questions in the body of your post.

[Wirral Wizard]

Thank you shg, great solution! Apologies for not posting the question in the correct manner, I thought it would be easier in the spreadsheet...will make sure I do it right next time. Thanks again.