Using multiple conditions with countif

Hi,

I have the following data.
A B C D
4 2 6 1
5 1 2 0
6 2 4 0
7 2 8 1
8 2 2 1
9 3 1 1

How do I count the number of rows that meet the following criteria?

D1:D6 = 1 & (A1:A6 - B1:B6) > 2 & (A1:A6)-(C1:C6) > 2

Thanks!

Originally Posted by Bo_Ry

Please try
=SUMPRODUCT((D1:D6=1)*(A1:A6-B1:B6>2)*(A1:A6-C1:C6>2))

Thank you!