View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default Count Number of Times Q

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