Hi,
I'm looking for a formula which will count the number of times a value of less than 0 appears in column AT, but will only count this if the value 1 does not appear in the corresponding row in column E and column F. e.g.
E F AT
7 1 -4
8 0
9 -3
10 1 -2
11 -1
In the above example, the calculation would exclude rows 7 and 10 as there is a "1" in column E or F. I would therefore count rows 9 & 11 with a value below 0 and the answer would be 2.
Thanks
Bookmarks