Creating a forumla across multiple sheets

D

dvk

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.
 
P

Peo Sjoblom

Like this

=SUM(Sheet2:Sheet3!A2:A8)


--

Regards,

Peo Sjoblom

dvk said:
Hi,

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

Don Guillett

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
 
D

dvk

Ah.. thanks.

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

=SUM(Sheet2:Sheet3!A2:A8)


--

Regards,

Peo Sjoblom

dvk said:
Hi,

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