Need to 'COUNT'...

[Guest]

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.

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(F1:F6-G1:G6>0))

 

[Peo Sjoblom]

=SUMPRODUCT(--(F1:F10>G1:G10))

adapt to fit your own ranges

 

[Guest]

This works great ! Thank you !
--
Wendy

One way:

=SUMPRODUCT(--(F1:F6-G1:G6>0))

 

[Guest]

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

 

[Ragdyer]

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>