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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing across multiple worksheets in excel 2007 3
Using the answer IF "true" in another formula? 1
If function 2
show the sum of an arbitary selection of cells 1
Cell reference between worksheets 1
SUM function across multiple worksheets within one workbook 4
Sumif across Multiple sheets 2
Cell Ref. in Formula changes automatically 1

Back
Top