Formulas

G

Guest

I have two columns of numbers. I need a formula to tell me how many of the
numbers in column A are less than the numbers in column B.
 
G

Guest

for column A less than Column B
one of the methods would be
=SUM(IF(A:A<B:B,1,0))
entered as an array (Control-shift enter)
 
J

JulieD

Hi

not sure if you can use entire columns in this formula (doesn't work for me
anyway) however,
=SUM(IF(A1:A1000<B1:B1000,1,0))
entered as an array (Control-shift enter)
does work.
 
G

Guest

mea culpa, I tried a short list and did not verify with the whole column.
Thanks for catching it.
 

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

Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
counting blank cells within two columns 2
select a range in a column 4
formula error 1
Excel Subtracting multiple columns from another column 3
I want to compare totals and flag those less than or more than 1
Formula question 2
Greater Than Symbols and calculations 0

Top