SUM cell F5 in sequential worksheets

  • Thread starter Thread starter sbd85
  • Start date Start date
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.
 
=Sum('page1:page9'!F5)

Average would be the same.

'etc' may not be appropriate. Very few functions support 3D range
references.
 
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.
 
Back
Top