I'm a newbie please help with my function

[colincannon]

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 colum
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 large
in a seperate cell. Is this possible. I cruised around the forum an
I did not see what I was looking for so any help would be appreciated

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100>B1:B100))

--

HTH

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


"colincannon" <[email protected]>
wrote in message
news:[email protected]...

 

[BenjieLop]

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 colum
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 large
in a seperate cell. Is this possible. I cruised around the forum an
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 an
Cells B2:B100.

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

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

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

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

=if(C2>0,A2,"")

and copy down until Cell D100.

Hope this is what you are looking for.

Regards

 

[Route2391]

=SUM(--(A1:A100>B1: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