I have two columns of numbers. I need a formula to tell me how many of the
numbers in column A are less than the numbers in column B.

for column A less than Column B
one of the methods would be
=SUM(IF(A:A<B:B,1,0))
entered as an array (Control-shift enter)

"Roberta" wrote:

I have two columns of numbers. I need a formula to tell me how many of the
numbers in column A are less than the numbers in column B.

Hi

not sure if you can use entire columns in this formula (doesn't work for me
anyway) however,
=SUM(IF(A1:A1000<B1:B1000,1,0))
entered as an array (Control-shift enter)
does work.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"bj" wrote in message
...
for column A less than Column B
one of the methods would be
=SUM(IF(A:A<B:B,1,0))
entered as an array (Control-shift enter)

"Roberta" wrote:

I have two columns of numbers. I need a formula to tell me how many of
the
numbers in column A are less than the numbers in column B.

mea culpa, I tried a short list and did not verify with the whole column.
Thanks for catching it.

"JulieD" wrote:

Hi

not sure if you can use entire columns in this formula (doesn't work for me
anyway) however,
=SUM(IF(A1:A1000<B1:B1000,1,0))
entered as an array (Control-shift enter)
does work.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"bj" wrote in message
...
for column A less than Column B
one of the methods would be
=SUM(IF(A:A<B:B,1,0))
entered as an array (Control-shift enter)

"Roberta" wrote:

I have two columns of numbers. I need a formula to tell me how many of
the
numbers in column A are less than the numbers in column B.