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

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 10Then 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

That did it!! It's beautiful!! Thanks!

Ask Your Question

Weekly Poll