SUM cell F5 in sequential worksheets

S

sbd85

I've lost this formula (done it before) and it doesn't show in HELP.

I want to SUM('page1'!F5 to 'page9'!F5)... AVERAGE etc too. SUM
is for the same cell in all intervening sheets.

Please help with context. Thanks.
 
T

Tom Ogilvy

=Sum('page1:page9'!F5)

Average would be the same.

'etc' may not be appropriate. Very few functions support 3D range
references.
 
H

Harlan Grove

Tom Ogilvy said:
=Sum('page1:page9'!F5)

Average would be the same.

'etc' may not be appropriate. Very few functions support 3D range
references.
Click to expand...
....

Oddly (or maybe 'as expected' since this is Excel under discussion), MEDIAN
supports 3D references but MODE doesn't (at least not through XL2K).

Interestingly, the great exception to most Excel worksheet function rules,
NPV, supports 3D references. What makes this highly notable is that NPV
*must* iterate through entries its 2nd and subsequent arguments in a
well-defined order, so lack of defined iteration order isn't the reason 3D
references aren't supported in more worksheet functions. Certainly, that
MODE doesn't support them is absurd.
 
Top