Jason, Peo:
All your suggestions work great. Thank you!!

"Jason Morin" wrote:

=COUNTIF(INDIRECT("Actions!I2:I"&C2),"*all*")

or

=COUNTIF(OFFSET(I2,,,C2-1),"*all*")

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to use the value on one cell to form the
range part an a countif
formula in another cell like this:
=COUNTIF(Actions!I2:I&"C2","*all*")

where C2 is the cell in the current worksheet whose
contents (currently 20)
I want to use. The contents will change periodically.
The formula that I
want evaluated would look like:
=COUNTIF(Actions!I2:I20,"*all*")

Anyone have a suggestion, please?
.