Formula over multiple sheets

S

SupportX

Subject: Formula over multiple sheets

Hi,

How can I create a forumula that involvs cells in multiple sheets?

Thanks,

Sup.
 
P

PCLIVE

I'm not sure exactly what you're trying to do.
Here's a simple formula that adds cell B15 on Sheet2 and B15 on Sheet3.

=Sheet2!B15+Sheet3!B15

Regards,
Paul
 
D

Dave Peterson

Type = to start the formula.
Then use the mouse to go to another worksheet and point at a cell.

type the next operand (maybe + to add)

point at the next cell.

You could end up with something like:

=Sheet1!B10+Sheet4!B21
 
R

Roger Govier

Hi

Try
=SUM(Sheet1:Sheet5!A1)
or
=SUM(First:Last!A1)
Creat a Sheet called First and one called Last. Drga them to outside the
range of sheets you want summed, and everything within the First .... Last
"sandwich" will be summed.

I prefer to keep the sheet with the summary formula on it outside of the
range to prevent any possibility of a Circular Reference error.

Regards

Roger Govier
 
Top