Posted on 2011-04-29
I have a multi tab spreadsheet with a first tab which is a summary tab.
To illustrate what I'm trying to do consider the following:
If the tabs are named RED, WHITE, BLUE, and on the SUMMARY tab I want to have a formula that says : =RED!A1+WHITE!A1+BLUE!A1 which in Cell A1 of the SUMMARY tab reports the result. Here's the qustion: is there a way on the summary tab that I can reference the names RED WHITE and BLUE (as words located in 3 separate cells on the SUMMARY spreadsheet) so that I can achieve teh same outcome as the formula listed, but referencess these 3 cells on the Summary sheet containing the names RED, WHITE and BLUE - like "injecting" the tab name into the formula. Thanks in advance