+ Reply to Thread
Results 1 to 4 of 4

how to write an average function when skipping rows?

  1. #1
    Forum Contributor
    Join Date
    06-24-2008
    MS-Off Ver
    2007
    Posts
    139

    how to write an average function when skipping rows?

    I'm using the function =average(u3:u7)
    I want to space the rows, now the values will be in cells u3, u5, and u7 (not u3, u4, u5).
    How can I write this formula to make it average every other cell?

  2. #2
    Forum Contributor
    Join Date
    06-24-2008
    MS-Off Ver
    2007
    Posts
    139
    Just thought about it (u3,u5,u7).

    Thanks anyway!

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653
    =AVERAGE(IF(MOD(ROW(U3:U7), 2) = 1, U3:U7) )

    This is an array formula, meaning it MUST be confirmed with Ctrl+Shift+Enter, not just Enter. (With the cursor in the formula bar, hold down Ctrl and Shift, then press Enter.) You'll know you did it correctly if curly braces appear around the formula in the Formula Bar; you cannot type in the braces directly.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Contributor
    Join Date
    06-24-2008
    MS-Off Ver
    2007
    Posts
    139
    thanks shg!

+ 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. How does this code output the coefficients of a trendline?
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-13-2010, 05:54 PM
  2. Loop through rows of list & logical test - vba function?
    By Sauvenix in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2008, 08:48 AM
  3. Average in rows
    By adsxvii in forum Excel General
    Replies: 5
    Last Post: 12-02-2007, 09:10 PM
  4. Average Function with Rounding
    By billykiller05 in forum Excel General
    Replies: 2
    Last Post: 11-06-2006, 01:12 PM
  5. IF function that eliminates empty rows
    By abrazee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2006, 12:29 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