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")
=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")