From: gu on 19 Apr 2010 14:44 How can i create a data table in excel 2007, with inputs, formulas and calculation from a diferent worksheet?
From: Bernard Liengme on 19 Apr 2010 15:15 If the cell A1 of Sheet2 has the value 10, then the formula =Sheet2!A1 will return the value 10 Let's say I want to make the a formula on Sheet1 to sum a range D1:D5 on Sheet2: Type =SUM(; open Sheet2, and select the range D1:D5, type ); click the green check mark in Formula Bar or press Enter key to commit formula Not that if the sheet's name has spaces in it I will get a formulas like =SUM('Jan Sales'!D1:D5 - observe the single quotes Does this answer your question? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "gu" <gu(a)discussions.microsoft.com> wrote in message news:5874DAD1-710F-4F81-B12B-3BADAEFFFDE8(a)microsoft.com... > How can i create a data table in excel 2007, with inputs, formulas and > calculation from a diferent worksheet?
|
Pages: 1 Prev: Adding some list items Next: conditional formatting = or > cell reference + 2 |