ExcelBanter - How do I compare two columns and return a number count

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

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

- - How do I compare two columns and return a number count (https://www.excelbanter.com/excel-worksheet-functions/195754-how-do-i-compare-two-columns-return-number-count.html)

9274211

How do I compare two columns and return a number count

I've got a list with two columns with number values that I need to compare.

Eg. compare column A with column B for each single row. Count the number of
rows if Column A is less than Column B (for each individual row, not total
value).

Is it possible to do that?

Teethless mama

How do I compare two columns and return a number count

=SUMPRODUCT(--(A1:A100<B1:B100))

"9274211" wrote:

I've got a list with two columns with number values that I need to compare.

Eg. compare column A with column B for each single row. Count the number of
rows if Column A is less than Column B (for each individual row, not total
value).

Is it possible to do that?

9274211

How do I compare two columns and return a number count

Thanks! Its very helpful.

"Teethless mama" wrote:

=SUMPRODUCT(--(A1:A100<B1:B100))

"9274211" wrote:

I've got a list with two columns with number values that I need to compare.

Eg. compare column A with column B for each single row. Count the number of
rows if Column A is less than Column B (for each individual row, not total
value).

Is it possible to do that?

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