+ Reply to Thread
Results 1 to 5 of 5

Get average from U3 through U (And row number identified in AC2)

  1. 01-28-2014, 07:49 AM #1
    nenadmail
    nenadmail is offline
    Forum Contributor
    Join Date
    05-19-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    200

    Get average from U3 through U (And row number identified in AC2)

    I'm trying to figure out this formula, this is what I have so far...

    =AVERAGE(U3:U(ROW(AC2)))
    It's returning a result of 0. Should be 10 according to my data.

    I'm trying to Average range column "U" row "3" through column "U" row (row number identified in AC2). How shoud that be written?

    Thanks!
    Reply With QuoteRegister To Reply
  2. 01-28-2014, 07:55 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Get average from U3 through U (And row number identified in AC2)

    Hi,

    =AVERAGE(U3:INDEX(U:U,AC2))

    (Preferable to the volatile alternative: =AVERAGE(INDIRECT("U3:U"&AC2)))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 01-28-2014, 07:55 AM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Get average from U3 through U (And row number identified in AC2)

    Try this.......

    Please Login or Register  to view this content.
    Is this what you want?
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 01-28-2014, 07:57 AM #4
    AL1976
    AL1976 is offline
    Forum Contributor
    Join Date
    01-22-2014
    Location
    genoa, italy
    MS-Off Ver
    Excel 2007
    Posts
    134

    Re: Get average from U3 through U (And row number identified in AC2)

    =average(u3:indirect("u"&ac2))
    Reply With QuoteRegister To Reply
  5. 01-28-2014, 08:14 AM #5
    nenadmail
    nenadmail is offline
    Forum Contributor
    Join Date
    05-19-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    200

    Re: Get average from U3 through U (And row number identified in AC2)

    Thanks that worked!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find Average, Return Column Header of Number Closest To Average
    By djmyers in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-07-2013, 04:19 PM
  2. Last Row not being identified correctly
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2011, 04:34 PM
  3. Empty cell Identified
    By Brian Matlack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2005, 11:05 AM
  4. Can cells containing linked formulas be identified?
    By EA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] Can cells containing linked formulas be identified?
    By EA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1