Count Number of Times Q
 

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

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

Count Number of Times Q
 

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

Count Number of Times Q
 

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"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

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

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