Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a shortcut?
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.......? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a shortcut?
=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.......? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a shortcut?
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.......? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut Keys -- quick find | Excel Discussion (Misc queries) | |||
Deactivate shortcut keys in excel.. | Excel Discussion (Misc queries) | |||
Isolating a Keyboard Shortcut | Setting up and Configuration of Excel | |||
how can you customize a shortcut menu in excel? | Excel Discussion (Misc queries) | |||
Shortcut menu does not have hyperlink on it | Excel Discussion (Misc queries) |