Countif([range], Cell?)
 

Hi All,

I've trying to do a countif on a range to count the number of records that
exceed the value in cell C2.

The value in C2 will vary so I can't just write that value into the formula.

Anyone know how to do this?
--
Adam
-----------
Windows XP + Office Pro XP

Countif([range], Cell?)
 

Try this

=COUNTIF(A1:A10,""&C2)

Mike

"Adam" wrote:

Hi All,

I've trying to do a countif on a range to count the number of records that
exceed the value in cell C2.

The value in C2 will vary so I can't just write that value into the formula.

Anyone know how to do this?
--
Adam
-----------
Windows XP + Office Pro XP

Countif([range], Cell?)
 

Awesome - thank you!

--
Adam
-----------
Windows XP + Office Pro XP


"Mike H" wrote:

Try this

=COUNTIF(A1:A10,""&C2)

Mike

"Adam" wrote:

Hi All,

I've trying to do a countif on a range to count the number of records that
exceed the value in cell C2.

The value in C2 will vary so I can't just write that value into the formula.

Anyone know how to do this?
--
Adam
-----------
Windows XP + Office Pro XP

Countif([range], Cell?)
 

your welcome

"Adam" wrote:

Awesome - thank you!

--
Adam
-----------
Windows XP + Office Pro XP


"Mike H" wrote:

Try this

=COUNTIF(A1:A10,""&C2)

Mike

"Adam" wrote:

Hi All,

I've trying to do a countif on a range to count the number of records that
exceed the value in cell C2.

The value in C2 will vary so I can't just write that value into the formula.

Anyone know how to do this?
--
Adam
-----------
Windows XP + Office Pro XP