Creating a forumla across multiple sheets

's Computer Specifications

Hi,

Newbie question: I have a project with 2 sheets in it. But I need to make a formula that involves both sheets. Is that possible? how?

Thanks you very much.

's Computer Specifications

Like this

=SUM(Sheet2:Sheet3!A2:A8)

--

Regards,

Peo Sjoblom

"dvk" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> Newbie question: I have a project with 2 sheets in it. But I need to make
a formula that involves both sheets. Is that possible? how?
>
> Thanks you very much.
>
>

's Computer Specifications

IF you mean you want the same formula on two or more sheets.Select the sheet
tabs>select one of the sheets>type in formula

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"dvk" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> Newbie question: I have a project with 2 sheets in it. But I need to make
> a formula that involves both sheets. Is that possible? how?
>
> Thanks you very much.
>
>

's Computer Specifications

Ah.. thanks.

----- Original Message -----
Like this

=SUM(Sheet2:Sheet3!A2:A8)

--

Regards,

Peo Sjoblom

"dvk" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> Newbie question: I have a project with 2 sheets in it. But I need to make
a formula that involves both sheets. Is that possible? how?
>
> Thanks you very much.
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating Multiple summary sheets	Tony	Microsoft Excel Misc	0	13th Jan 2010 12:56 AM
Creating multiple sheets with a macro	syrney170	Microsoft Excel Discussion	1	13th Jan 2006 01:05 AM
Creating multiple sheets - new to programming	Ivorh via OfficeKB.com	Microsoft Excel Programming	0	1st Dec 2005 10:53 PM
Creating a workbook with multiple sheets	Gregg	Microsoft Excel Worksheet Functions	0	4th Mar 2004 02:34 PM
creating charts on multiple sheets	tom	Microsoft Excel Charting	0	8th Aug 2003 03:27 PM