Need to 'COUNT'...
 

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

Need to 'COUNT'...
 

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.

Need to 'COUNT'...
 

=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

Need to 'COUNT'...
 

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.

Need to 'COUNT'...
 

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

Need to 'COUNT'...
 

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