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.