G
Guest
I have 2 different rows with different values in 6 columns set up as such
Row 1: 110010
Row 2: 502345
I am trying to write a formula to count the instances where row 2 is > 0 and
row 1 = 1
So in this instance, row 2 > 0 in all but the second column (column B); row
1 = 1 in columns A, C and E
Therefore, the total could be 2 b/c both criteria are meant in column A and E
Help?
Row 1: 110010
Row 2: 502345
I am trying to write a formula to count the instances where row 2 is > 0 and
row 1 = 1
So in this instance, row 2 > 0 in all but the second column (column B); row
1 = 1 in columns A, C and E
Therefore, the total could be 2 b/c both criteria are meant in column A and E
Help?