+ Reply to Thread
Results 1 to 3 of 3

averaging values if a certain name is next to it

Hybrid View

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    New York, New York
    MS-Off Ver
    2010
    Posts
    1

    averaging values if a certain name is next to it

    I am trying to figure out how I could find an average of values if and only if a certain name is next to it.

    example.xlsx

    in the example text, I want to find the average of all the cells that have "bob" in column B. I want it to be the entire column and not just part of it. I have been looking around but I have not found what I was looking for.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: averaging values if a certain name is next to it

    Add the numbers corresponding to bob
    =SUMIF(B1:B12,"bob",A1:A12)
    Count the number of times bob appears
    =COUNTIF(B1:B12,"bob")
    Calculate bobs average
    =SUMIF(B1:B12,"bob",A1:A12)/COUNTIF(B1:B12,"bob")

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: averaging values if a certain name is next to it

    Simply..

    =AVERAGEIF(B:B,"bob",A:A)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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: 12
    Last Post: 09-04-2013, 03:55 PM
  2. [SOLVED] Help with Averaging the Values
    By johnabrahambio in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-01-2012, 08:45 AM
  3. Averaging values based on seperate column values
    By beng404 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2011, 10:07 AM
  4. Averaging ever so many values
    By becksell2001 in forum Excel General
    Replies: 3
    Last Post: 08-03-2009, 09:59 AM
  5. Replies: 0
    Last Post: 08-29-2005, 07:45 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