Call on a Cell According to Another Cell?

[bsol]

Essentially I have a simple formula like =COUNTIF(C11:C15,"*whatever*")

Rather than use the numbers 11 and 15, I would like those numbers to be determined by two different cells (say cells A1 and A2) so that I can change the range on the fly.

How do I do this? Please let me know if this isn't clear.

[day92]

You can just make the range A1:A2 right? I must be missing something here?

[bsol]

No that is not what I mean.

So I'm doing =COUNTIF(C11:C15,"*whatever*").

Ideally, what I want is =COUNTIF(C(A1):C(A2),"*whatever*") but that is not the syntax excel uses.

If I make A1=11 and A2=15 then I have the same thing as above. But I want to be able to change those values on the fly. Make sense? I'm sure there is a simple way to do it, but I don't know what the proper syntax is.

[siva972377]

=COUNTIF(indirect("C"&A1&":"&"C"&A2),"*whatever*")