Excel Formula

Posted on 2011-04-29
Last Modified: 2012-05-11
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
Question by:starport
    LVL 33

    Accepted Solution

    No but you could name your A1 cells. On RED tab cell A1, you can create a named range like RED; on your cell A1 of tab WHITE you can create a named range with the name WHITE, etc... Then on a cell you can do =RED+WHITE+BLUE that will sum the values of cell A1 from each tab.

    Please take a look at the attached example.

    LVL 33

    Expert Comment

    LVL 43

    Assisted Solution

    by:Saqib Husain, Syed

    will give the value in A1 of the sheet whose name is in A1 of the current sheet.
    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    See attached sample

    Author Closing Comment

    Exactly what I Needed, thanks so much

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now