=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