Excel: adding indirect values


currently have =INDIRECT("'"&A1&"'!"&"C10") which shows the sheet name in A1 and the value in C10 If i wanted to add C10+C20+c32 whats the easiest way or if a range i.e. C10:C16 DO i have to use =INDIRECT("'"&A1&"'!"&"C10") +INDIRECT("'"&A1&"'!"&"C10")+=INDIRECT("'"&A1&"'!"&"C32")


This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of April 30, 2015.


For more resources for Microsoft Excel