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?
|