Results 1 to 11 of 11

how do i autofill averages for ranges that dont share the dimensions of the average column

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2017
    Location
    miami, florida
    MS-Off Ver
    2010
    Posts
    35

    how do i autofill averages for ranges that dont share the dimensions of the average column

    on sheet 2 i have monthly tables of hours worked for 8 people. On the side there a table for monthly averages.
    how do i autofill the averages of the monthly charts into my average charts. its not arrange in way that the relative cell reference would shift automatically into the correct cell/range.practice income sheet.xlsx
    this should have it
    Attached Files Attached Files
    Last edited by businpro; 11-09-2017 at 10:05 AM. Reason: wrong upload

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 03-13-2015, 05:34 AM
  2. [SOLVED] need formula to average cells but if one cell has N/A then dont average and input N/A
    By CityInspector in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2013, 04:16 PM
  3. Replies: 1
    Last Post: 07-29-2013, 07:35 PM
  4. Replies: 3
    Last Post: 02-07-2012, 09:05 AM
  5. Copy range and autofill ranges dependent on cell count in column A
    By thylander in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2011, 09:26 AM
  6. Ranking Ranges of differing dimensions
    By KevinThomas in forum Excel General
    Replies: 4
    Last Post: 07-08-2009, 04:28 AM
  7. Autofill with different average ranges
    By kguillen in forum Excel General
    Replies: 3
    Last Post: 04-07-2009, 07:27 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1