MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Forumla between worksheets in same workbook


Posted by John on December 03, 2001 4:20 PM

Hello,

I have a simple =SUM formula. However, the data that I want to add is in another wooksheet in the same workbook.

Usually, I would just type =SUM(F3:F890) but now I know I need to add something to tell it to look at the other worksheet, but I can't find what that is in the Help file.

Help!

John, Excel inept


Posted by IML on December 03, 2001 4:48 PM

You could use
=SUM(Sheet2!D15:G24)
where you are adding from sheet 2. Excel is friendly in that you can just point to the sheet you want to add once you are in the formula.
Also if you want to add, say cell A1 on sheets 2 and 3, you could use
=SUM(Sheet2:Sheet3!A1)

good luck