+ Reply to Thread
Results 1 to 2 of 2

Average a row and skipping columns

  1. #1
    Registered User
    Join Date
    10-06-2014
    Location
    Greenbelt, Maryland
    MS-Off Ver
    2010
    Posts
    10

    Average a row and skipping columns

    I'm looking for a formula that will average my actuals based on the user selecting the months they want and skipping columns S16:AA16. Drop down box for month is located in cell X5 & Y5. The formula will start in X19 which is highlighted in yellow. Actuals to average start in G16:AM16

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Average a row and skipping columns

    This formula, entered as an array formula with CTRL+SHIFT+ENTER, will return what you are looking for:

    Please Login or Register  to view this content.
    However, I had to alter how your month labels were displayed in Excel in order for the date criteria (cells X5 and Y5) to work correctly. The attached workbook should display the correct results, but I did not enter the formula because I was unsure of where you wanted it to go.

    EDIT:

    After re-reading your requirements, input the formula above into cell X19 as an array formula for the result you are looking for.
    Attached Files Attached Files
    Last edited by mcmahobt; 10-21-2015 at 03:52 PM. Reason: Re-read requirements
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 10-21-2013, 10:56 AM
  2. IF(MOD) for skipping columns
    By rhudgins in forum Excel General
    Replies: 5
    Last Post: 07-31-2010, 02:16 AM
  3. how to write an average function when skipping rows?
    By novice2430 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-21-2008, 04:26 PM
  4. Skipping Columns
    By enricospada@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2006, 06:08 PM
  5. Sum skipping columns
    By Steve in forum Excel General
    Replies: 5
    Last Post: 04-25-2005, 01:06 PM
  6. skipping columns part 2
    By Wazooli in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-19-2005, 04:06 PM
  7. [SOLVED] skipping columns
    By Wazooli in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-19-2005, 02:06 PM

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