Count Number of Times Q

[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

 

[Guest]

Try something like this:

With your posted example

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


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

XL2002, WinXP

 

[Ragdyer]

Try this:

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

 

[Bob Phillips]

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Sean]

Ragdyer, spot on, Thanks

Try this:

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

 

[RagDyeR]

Appreciate the feed-back.

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