Not sure if this is possible...
COLUMN F COLUMN G
6,942 292
317 0
6,207 20,374
417 17,588
43,921 108,193
5,974 15,883

Need to count those cells in COLUMN F whose number is greater
than the corresponding number in COLUMN G. Any help would be
greatly appreciated.

--
Wendy

One way:

=SUMPRODUCT(--(F1:F6-G1:G60))

In article ,
Wendy wrote:

Not sure if this is possible...
COLUMN F COLUMN G
6,942 292
317 0
6,207 20,374
417 17,588
43,921 108,193
5,974 15,883

Need to count those cells in COLUMN F whose number is greater
than the corresponding number in COLUMN G. Any help would be
greatly appreciated.

=SUMPRODUCT(--(F1:F10G1:G10))

adapt to fit your own ranges



--
Regards,

Peo Sjoblom

"Wendy" wrote in message
...
Not sure if this is possible...
COLUMN F COLUMN G
6,942 292
317 0
6,207 20,374
417 17,588
43,921 108,193
5,974 15,883

Need to count those cells in COLUMN F whose number is greater
than the corresponding number in COLUMN G. Any help would be
greatly appreciated.

--
Wendy

This works great ! Thank you !
--
Wendy


"JE McGimpsey" wrote:

One way:

=SUMPRODUCT(--(F1:F6-G1:G60))

In article ,
Wendy wrote:

Not sure if this is possible...
COLUMN F COLUMN G
6,942 292
317 0
6,207 20,374
417 17,588
43,921 108,193
5,974 15,883

Need to count those cells in COLUMN F whose number is greater
than the corresponding number in COLUMN G. Any help would be
greatly appreciated.

This works as well !!!
Thank you for the quick response.


--
Wendy


"Peo Sjoblom" wrote:

=SUMPRODUCT(--(F1:F10G1:G10))

adapt to fit your own ranges



--
Regards,

Peo Sjoblom

"Wendy" wrote in message
...
Not sure if this is possible...
COLUMN F COLUMN G
6,942 292
317 0
6,207 20,374
417 17,588
43,921 108,193
5,974 15,883

Need to count those cells in COLUMN F whose number is greater
than the corresponding number in COLUMN G. Any help would be
greatly appreciated.

--
Wendy

Just got a twitch of nostalgia with this thread.

Years back, when I first tripped over these NGs, when Tom Ogilvy was the
*top* poster, and every morning (my morning), as I read down the list of
posts, I would marvel at how you two guys would somehow alternate as the
first responder to most of the unanswered posts that were present.
I was amazed at how one would beat out the other by a mere minute or two,
with the same correct suggestion or an alternate one.

You two taught me a hell of a lot, back then, *not* that I've stop learning
from you now!

Seems we all had more time ... back then!

Ahhh ... the good old days!<bg

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
=SUMPRODUCT(--(F1:F10G1:G10))

adapt to fit your own ranges



--
Regards,

Peo Sjoblom

"Wendy" wrote in message
...
Not sure if this is possible...
COLUMN F COLUMN G
6,942 292
317 0
6,207 20,374
417 17,588
43,921 108,193
5,974 15,883

Need to count those cells in COLUMN F whose number is greater
than the corresponding number in COLUMN G. Any help would be
greatly appreciated.

--
Wendy