View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Count Number of Times Q

Try something like this:

With your posted example

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


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Sean" wrote:

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