countif comparing two columns

J

Johndb

Please help.

I have two colums of data I need to compare, roughly 100 rows each. I need
to count a given row if the value in column b is greater than the number in
column a. There are a few alpha letters in each row. I have scoured and
tested everything I have seen posted regarding countif, sumif, sumproduct,
etc. and I can't seem to get it to work. Any assistance would be greatly
appreciated.

Thanks in advance,

John
 
J

Jacob Skaria

Why don't you post some sample data and explain what you are expecting..so
that some one can help you OR point you in the right direction.
 
J

Jacob Skaria

Do you mean the below...where you have data in ColA and ColB..the below
formula will count the rows in which both columns are numerics and colB is
greater than ColA.

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula>}"

=SUM(IF(ISNUMBER(A1:A100),IF(ISNUMBER(B1:B100),IF(B1:B100>A1:A100,1,0))))

If this post helps click Yes
 
J

Johndb

Jacob,

This was perfect, I am an intermediate user and I wasn't anywhere near this
line of thought. Thanks a heap.

Warmest Regards,

John
 

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

Top