How do I compare two columns and return a number count

9

9274211

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif comparing two columns 4
How can I count deviations between two rows? 3
matching & combining data from seperate worksheets 2
Comparing two columns and return a third 3
Excel Subtracting multiple columns from another column 3
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT 9
Compare sheet 1 column A numbers with sheet 2 column A number 2
HOW TO COMPARE THREE NUMBER AND USE THE HIGHER NUMBER IN A FORMUL. 3

Top