PDA

View Full Version : Solved: Cell Reference, No VBA Required



Anne Troy
06-29-2005, 06:18 PM
I can never remember how to do this.

Suppose I have a worksheet name in cell A2 (which I do).

Suppose in C2, I want to SUM(C2:C65536) from the worksheet whose name is in A2.

=SUM(SomeWayToGetWorksheetNameFromA2!C2:C65536)

Thanks!

Jacob Hilderbrand
06-29-2005, 06:38 PM
=SUM(INDIRECT(A2&"!C2:C65536"))

Anne Troy
06-29-2005, 06:47 PM
Thanks, Jake. Now why the heck do I always try to put the quotes on the first part instead of the second?? Geesh!!

Jacob Hilderbrand
06-29-2005, 07:39 PM
Glad to help. :beerchug:

Take Care