View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Count Number of Times Q

Appreciate the feed-back.

Not too often do we see a triple dead-heat.<bg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Sean" wrote in message
oups.com...
Ragdyer, spot on, Thanks


Ragdyer wrote:
Try this:

=COUNTIF(A1:A35,""&A36)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sean" wrote in message
ups.com...
How would I count the number of Times each cell in a Range is Greater
than another cell?

Example. For each cell in the Range A1:A35 how many times each one is
Greater than the value in Cell A36

Thanks