Countif criteria in another cell

[Guest]

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 ?

 

[Bob Phillips]

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

--
---
HTH

Bob

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

 

[Guest]

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.

 

[Guest]

Perfect -- thanks so much.

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.