Hi

=COUNTIF(INDIRECT(A1),ValueToCount)
where cell A1 contains the reference string - like "X1:X100"


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"JK" wrote in message
...
I am wondering of there is a way to allow the range in countif to vary. I
am
trying to make an analysis template that the user can specify the range
without having to go into the cell and re-specify it in the coutif
funciton.
Is this possible? Or am I barking up the wrong tree?
Thanks.
-JK