Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula to Search and Average (Excel-Any)

    I need your help to think this formula through. I have names in column A and values in column B. I want to search column A for the names Sarah and Woody, and get the average of their associated values. Is there a quick way to do this? It's Friday and my brain is fried....thanks!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula to Search and Average (Excel-Any)

    =SUMIF(A:A,"Sarah",B:[img]/forums/images/smilies/cool.gif[/img]/countif(A:A,"Sarah")
    =SUMIF(A:A,"Woody",B:[img]/forums/images/smilies/cool.gif[/img]/countif(A:A,"Woody")

    Steve

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula to Search and Average (Excel-Any)

    Thanks, Steve! That jump-started my thought process. Now, what if I wanted to add all of the values I find and average both Sarah's and Woody's together?

    I have this formula, but it's taking the average of the averages.
    =((SUMIF(A:A,"Sarah",B:[img]/forums/images/smilies/cool.gif[/img]/COUNTIF(A:A,"Sarah"))+(SUMIF(A:A,"Woody",B:[img]/forums/images/smilies/cool.gif[/img]/COUNTIF(A:A,"Woody")))/2

  4. #4
    Lounger
    Join Date
    Aug 2002
    Location
    MN, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula to Search and Average (Excel-Any)

    =(SUMIF(A:A,"Sarah",B:[img]/forums/images/smilies/cool.gif[/img]+SUMIF(A:A,"Woody",B:[img]/forums/images/smilies/cool.gif[/img])/(COUNTIF(A:A,"Sarah")+COUNTIF(A:A,"Woody"))

  5. #5
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula to Search and Average (Excel-Any)

    Thanks, Chaunce. I can rest easy this weekend!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •