Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

?
? asked in Computers & InternetSoftware · 9 years ago

excel formula between worksheets?

I need to show overall totals for each quarter by entering formulas that create links between the quarterly worksheets and the summary sheet.

The quarterly worksheets have been named as 1st Qtr, 2nd Qtr, 3rd Qtr, 4th Qtr & I can't change their names .

The cells on each Quarter page I need to use are F17 to go on the Summary page in column B.

Any help/advice would be great, thanks.

2 Answers

Relevance
  • crsimon36
    Lv 7
    9 years ago
    Favourite answer

    These are all Worksheets contained within the same Workbook? In your Summary page (sheet) where you want the totals to appear, start the formula, click on the 1st Qtr sheet tab then the cell F17 follow with a + sign from the keyboard and repeat for the remaining sheets. After the inclusion of 4th Qtr F17, press the enter key.

    I think your formula should look like this:

    =1st Qtr:F17+2nd Qtr:F17, etc. If this does not work, then perhaps it doesn't like the space you have in the sheet names. Change, yes you must, to something like 1st_Qtr

    On Edit: Sorry, I told you wrong. It should be ='1st Qtr'!F17+'2nd Qtr'!F17+'3rd Qtr'!F17+'4th Qtr

    !F17

  • Anonymous
    5 years ago

    i am going to attempt to rephrase what craazyladi reported: enable's say you've 2 sheets: "sheet a million" and "sheet 2", and the totals are in cellular D10 in both sheets. Then on your very last sheet, the position you want the grand entire, you would have the formula: ='Sheet a million'!D10 + 'Sheet 2'!D10

Still have questions? Get answers by asking now.