I have an excel spreadsheet that has 2 columns of numbers side by side.
I want a formula that counts the number of times the number in column
one are larger than the number that is right beside it in column two.
After it counts it I want to display the total number that are larger
in a seperate cell. Is this possible. I cruised around the forum and
I did not see what I was looking for so any help would be appreciated.


--
colincannon
------------------------------------------------------------------------
colincannon's Profile: http://www.excelforum.com/member.php...o&userid=26105
View this thread: http://www.excelforum.com/showthread...hreadid=394335

=SUMPRODUCT(--(A1:A100B1:B100))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"colincannon"
wrote in message
...

I have an excel spreadsheet that has 2 columns of numbers side by side.
I want a formula that counts the number of times the number in column
one are larger than the number that is right beside it in column two.
After it counts it I want to display the total number that are larger
in a seperate cell. Is this possible. I cruised around the forum and
I did not see what I was looking for so any help would be appreciated.


--
colincannon
------------------------------------------------------------------------
colincannon's Profile:
http://www.excelforum.com/member.php...o&userid=26105
View this thread: http://www.excelforum.com/showthread...hreadid=394335

colincannon Wrote:
I have an excel spreadsheet that has 2 columns of numbers side by side.
I want a formula that counts the number of times the number in column
one are larger than the number that is right beside it in column two.
After it counts it I want to display the total number that are larger
in a seperate cell. Is this possible. I cruised around the forum and
I did not see what I was looking for so any help would be appreciated.

ASSUME for this exercise that your numbers are in Cells A2:A100 and
Cells B2:B100.

Based on the above assumption, here is a very simple solution (I am
sure that there is a more elegant solution out there).

In Cell C2, enter this formula (without the quotes) "=A2-B2" and copy
down until Cell C100. We will call Column C (Cells C2 to C100) as a
helper column.

In cell C1, enter this formula: =countif(C2:C100,"0") and this will
count the "number of times the number in column one are larger than the
number that is right beside it in column two."

To display the numbers, you can enter this formula in Cell D2

=if(C20,A2,"")

and copy down until Cell D100.

Hope this is what you are looking for.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=394335

=SUM(--(A1:A100B1:B100))




I got a lot of my begginer help on this site... cool
They teach you by making a, Time sheet, Invoice and cheek book from
scratch on Windows media Player very cool

www.MDOTutorials.com


--
Route2391
------------------------------------------------------------------------
Route2391's Profile: http://www.excelforum.com/member.php...o&userid=26774
View this thread: http://www.excelforum.com/showthread...hreadid=394335