ExcelBanter - Comparing values in columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Comparing values in columns (https://www.excelbanter.com/excel-worksheet-functions/139492-comparing-values-columns.html)

Sandy

Comparing values in columns

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

Barb Reinhardt

Comparing values in columns

Try this

=SUMPRODUCT(--(A3:A30B3:B30))

"Sandy" wrote:

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

Sandy

Comparing values in columns

Perfect Barb - Thank you

"Barb Reinhardt" wrote in message
...
Try this

=SUMPRODUCT(--(A3:A30B3:B30))

"Sandy" wrote:

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

All times are GMT +1. The time now is 05:11 AM.