Count Number of Times Q

S

Sean

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
 
R

Ron Coderre

Try something like this:

With your posted example

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


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

XL2002, WinXP
 
B

Bob Phillips

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top