Comparing cells

[mad3]

I want to count the number of cells where the number in column b is greater than the number in column A.



Column A --------Column B


12 ------ 9
12 -----17
12 -----13
8 ------10
8 ------17
8 8

I want to be able to say in one click how many times column B is greater than the total in column A. In this case it would have been 4.

I have spreadsheets with total for over a thousand lines and need to be able to determine this info in one click.

Thanks in advance

Mike in Cali

 

[Trouttrap2]

will this work for you
=SUM(IF(B1:B1000>A1:A1000,1))
enter using Ctrl+Shft+Enter, not just enter b/c its an array.

I guess this works too. And its not an array.
=SUMPRODUCT((B1:B1000>A1:A1000)*(1))

Better yet
=SUMPRODUCT(--(B1:B1000>A1:A1000))

 

[mad3]

Thank you!

They both worked...


Much appreciated.