I have two columns, both containing some positive and some negative #s.
Right now, I have =COUNTIF($V$1:$V$57,"<0") to count the number of times there are negative values, and ">0" to count the positive values for each column.
I want to compare the two, to get a count of any time that a negative value in column X corresponds to a positive value in column V, and vice versa.
For example:
V X
200 (50)
431 542
(43) (56)
(43) 54
75 (13)
and so on.
So, in this case, I would like a function that gives me a count of the 2 times V is positive and X is negative, and the 1 time that X is positive and V is negative.
Let me know if you have any other questions - thanks!
Bookmarks