Solved Compare values between columns

July 25, 2012 at 12:04:51
Specs: Windows XP
Hi, I am trying to run a COUNTIFS formula that compares values in column B to column A. I want to count the rows, if in B the values therein are >= the adjacent values in A. Here is the formula I used =COUNTIFS(B:B,">="&A:A). The trick I think is that one column can't be greater than another. Is there another formula or trick that will yield what I want? I set up a simple test that should return 9. But it doesn't. Help please!

5 5
6 6
3 3
8 8
12 12
9 9
65 65
14 14
6 6
77 50
13 10
12 10


See More: Compare values between columns

Report •

#1
July 25, 2012 at 13:28:43
✔ Best Answer
Try this:

If your data looks like this:

    A    B
1)   5    5
2)   6    6
3)   3    3
4)   8    8
5)  12   12
6)   9    9
7)  65   65
8)  14   14
9)   6    6
10) 77   50
11) 13   10
12) 12   10

Then this ARRAY formula will give you your result:

=SUM(IF(B1:B12>=A1:A12,1,0))

You MUST you CTRL+SHIFT+ENTER for an Array formula to work. After entering the formula, don't just press enter.

MIKE

http://www.skeptic.com/


Report •

#2
July 25, 2012 at 13:46:42
That did it!! It's beautiful!!

Thanks!


Report •
Related Solutions


Ask Question