Countif with array problem

[PrinceUva]

Hello
Let say I have 2 columns A & B, with numbers from row 1 to 4. I want to count how many numbers in B are less than the adjacent one in A. So I did {=COUNTIF(B1:B4,"<"&A1:A4)}. but it is not working it is showing the wrong number. Is there an alternative way to do it or fix the formula?

 

[steve the fish]

Hi. Try this:

=SUMPRODUCT(--(A1:A4>B1:B4))

 

[PrinceUva]

Hello, thanks it seems to work.