Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2009
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm trying to figure out how to do a 3-D reference (formula) in multiple cells and sheets, ex: average for cells C9 through C 16 in sheet 1,2,3. Can someone please help me figure this out. thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can use a formula such as this:

    =AVERAGE('Sheet 1:Sheet 3'!C9:C16)

    where Sheet 1 is the first sheet to be included, and Sheet 3 the last one; the sheets should be contiguous.
    If you want to calculate an average over non-contiguous sheets, you must list them separately:

    =AVERAGE('Sheet 1'!C9:C16,'Sheet 4'!C9:C16,'Sheet 8'!C9:C16)

    Note: Excel will omit the single quotes around the sheet names if the names don't contain spaces.

  3. #3
    New Lounger
    Join Date
    May 2009
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for your help, everything worked out! Have a great day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •