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!
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks