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

Would you use "Spotlight Search" on Windows?

Discuss in The Lounge

Poll History