Formula over multiple sheets

[SupportX]

Subject: Formula over multiple sheets

Hi,

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

Thanks,

Sup.

 

[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

 

[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

 

[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