Hi,

Is there a short cut to adding up lots of different formulas from different
worksheets?

e.g. "='sheet 1'!F495+'sheet 2'!F495:H495+'sheet 3'!F495:H495+'sheet
4'!F495:H495+'sheet 5'!F495+'sheet 6'!F495

Athough i can use the auto fill for some cells the each worksheet has many
hundreds of cells i need to add up in a 'totals' sheeet.......?

=SUM(Sheet1!F495,Sheet2:Sheet6!F495:H495)



"Bryan" wrote in message
...
Hi,

Is there a short cut to adding up lots of different formulas from
different
worksheets?

e.g. "='sheet 1'!F495+'sheet 2'!F495:H495+'sheet 3'!F495:H495+'sheet
4'!F495:H495+'sheet 5'!F495+'sheet 6'!F495

Athough i can use the auto fill for some cells the each worksheet has many
hundreds of cells i need to add up in a 'totals' sheeet.......?

From the Excel help file:

Refer to the same cell or range on multiple sheets
A reference that refers to the same cell or range on multiple sheets is
called a 3-D reference.

Click the cell where you want to enter the function.
Type = (equal sign), enter the name of the function, and then type an
opening parenthesis.
Functions that can be used in a 3-D reference

SUM - adds numbers

AVERAGE - calculates average (arithmetic mean) of numbers

AVERAGEA - calculates average (arithmetic mean) of numbers; includes text
and logicals

COUNT - counts cells that contain numbers

COUNTA - counts cells that are not empty

MAX - finds largest value in a set of values

MAXA - finds largest value in a set of values; includes text and logicals

MIN - finds smallest value in a set of values

MINA - finds smallest value in a set of values; includes text and logicals

PRODUCT - multiplies numbers

STDEV - calculates standard deviation based on a sample

STDEVA - calculates standard deviation based on a sample; includes text and
logicals

STDEVP - calculates standard deviation of an entire population

STDEVPA - calculates standard deviation of an entire population; includes
text and logicals

VAR - estimates variance based on a sample

VARA - estimates variance based on a sample; includes text and logicals

VARP - calculates variance for an entire population

VARPA - calculates variance for an entire population; includes text and
logicals

Click the tab for the first worksheet to be referenced.
Hold down SHIFT and click the tab for the last worksheet to be referenced.
Select the cell or range of cells to be referenced.
Complete the formula, and press ENTER.


"Bryan" wrote:

Hi,

Is there a short cut to adding up lots of different formulas from different
worksheets?

e.g. "='sheet 1'!F495+'sheet 2'!F495:H495+'sheet 3'!F495:H495+'sheet
4'!F495:H495+'sheet 5'!F495+'sheet 6'!F495

Athough i can use the auto fill for some cells the each worksheet has many
hundreds of cells i need to add up in a 'totals' sheeet.......?