View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wendy Wendy is offline
external usenet poster
 
Posts: 99
Default 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