+ Reply to Thread
Results 1 to 2 of 2

Obtaining averages from ranges in one column dependent upon values in another column

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Obtaining averages from ranges in one column dependent upon values in another column

    example.PNG

    Hi.

    What we are trying to do is obtain the averages for certain cells in one column, depending on data in another column.

    For example (illustrated in the picture), we want to obtain the averages of data in column 2 for position 1, position 2, position 3 (column 1). We can do this manually by averaging the values, but because there are more than three positions, and because the number of rows vary between files, we are looking to create one set of formulas that we can use across multiple files.

    Thank you for your insight.
    Last edited by HIPstuff; 07-29-2013 at 07:15 PM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Obtaining averages from ranges in one column dependent upon values in another column

    Put this formula in C2, then copy that cell down:

    =IF(A2<>A3, AVERAGEIF(A:A, A2,B:B ), "")

+ 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. [SOLVED] Obtaining values from a reference cell in a different column and row
    By soxcrates in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2012, 07:40 AM
  2. Replies: 3
    Last Post: 05-02-2012, 04:43 PM
  3. Obtaining next value from a column in another workbook
    By larzep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2011, 12:53 AM
  4. 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
  5. Averages & VLOOKUP for Mulitple Values in Column
    By pmd in forum Excel General
    Replies: 2
    Last Post: 05-28-2010, 09:07 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