Can countif be used to look at criteria in another cell ? I've got a row of
numbers that I want to see how many of them are greater than a value in some
other cell. Can I do this ?

=COUNTIF(A:A,""&B1)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"rclough" wrote in message
...
Can countif be used to look at criteria in another cell ? I've got a row
of
numbers that I want to see how many of them are greater than a value in
some
other cell. Can I do this ?

Hi this link is good,

http://www.contextures.com/xlFunctions04.html

but it looks something like this

=COUNTIF(A1:Q3,""&C6)

Range, then Greater than, then cell

cell has & before it.
--
This post was created using recycled electrons!


"rclough" wrote:

Can countif be used to look at criteria in another cell ? I've got a row of
numbers that I want to see how many of them are greater than a value in some
other cell. Can I do this ?

Perfect -- thanks so much.

"Newbeetle" wrote:

Hi this link is good,

http://www.contextures.com/xlFunctions04.html

but it looks something like this

=COUNTIF(A1:Q3,""&C6)

Range, then Greater than, then cell

cell has & before it.
--
This post was created using recycled electrons!


"rclough" wrote:

Can countif be used to look at criteria in another cell ? I've got a row of
numbers that I want to see how many of them are greater than a value in some
other cell. Can I do this ?