Hello there,
I'm trying to build an excel software and I have a question.
I have a table like this in my sheet:
=======
100 | 100
200 | 400
305 | 300
... | ....
=======
Now I want to count cells in column two with a value greater than column one with a formula. For example the result is 1 for that table.
How can I do it?
Thanks!
c9and drag down.
Please Login or Register to view this content.
Then count the collumn C.
Or also possible.
Please Login or Register to view this content.
Last edited by oeldere; 06-16-2012 at 09:35 AM.
Just to be clear on the results you expect, what would be the result based on your example data?
Do you mean to compare adjacent cells or are you asking for the total number of cells that are greater than the maximum value in the first column?
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thanks, this is correct.
But is there any way else that doesn't need an extra column?
Sumproduct (see #2)
Good day,
the code in C9 should read
=if(B9>A9,1,0)
then = sum(C:C) will give you the count!
Click on star if your problem is solved!
Oh yes, but I meant the count of the values, not sum of them.
Is there any way to COUNT cells without extra column?
=sumproduct(--(b1:b10>a1:a10))
or
This array formula
{=COUNT(IF(B1:B10>A1:A10,B1:B10))}
Please Login or Register to view this content.
Yes, this is correct! Thanks for your help, friends!
Please reply in your answer to whome youre responding.
Which formala did you use.
This was useful for me.Originally Posted by Palmetto
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks