Hi Rob

Another alternative, would be to use Index rather than the volatile
Indirect function

=COUNTA(INDEX(C:C,A1):INDEX(C:C,B1))

--
Regards
Roger Govier

Rob wrote:
I have a formula =COUNTA(INDIRECT(A3)) which returns the count of items in a
range which is defined in cell A3, the formula in A3 is below. Is there a
way of not having to include the sheet name (Sheet 1) in cell A3 and to
include in the COUNTA formula.

="'Sheet 1'"&"!C"&A1&":"&"C"&B1

Thanks, Rob