Comparing values in columns

[Sandy]

Hi

What is the best way to compare values in columns as follows:-

A3:A30 contains integers as does B3:B30. What I would like to do is count
the number of values in Range B3:B30 that are less than equivalent values in
A3:A30. (Also those that are equal and those that are more than)

TIA
Sandy

 

[Guest]

Try this

=SUMPRODUCT(--(A3:A30>B3:B30))

 

[Sandy]

Perfect Barb - Thank you

Try this

=SUMPRODUCT(--(A3:A30>B3:B30))