+ Reply to Thread
Results 1 to 7 of 7

How do I count and average only the number that corresponds with the adjacent string?

  1. #1
    Registered User
    Join Date
    08-14-2017
    Location
    Liverpool, England
    MS-Off Ver
    2016
    Posts
    21

    Unhappy How do I count and average only the number that corresponds with the adjacent string?

    I'm an Excel trying to muddle through some things for work..

    How do I count and average only the number that corresponds with the adjacent string?

    I've attached a copy of the workbook and the picture below if anybody can help.

    forum average q.png
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How do I count and average only the number that corresponds with the adjacent string?

    You could try
    =AVERAGEIF($A$2:$A$10,D2,$C$2:$C$10)
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-14-2017
    Location
    Liverpool, England
    MS-Off Ver
    2016
    Posts
    21

    Re: How do I count and average only the number that corresponds with the adjacent string?

    What do the $ signs stand for?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How do I count and average only the number that corresponds with the adjacent string?

    See information about absolute and relative references.
    https://support.office.com/en-gb/art...e-5f0d8d0baca9

  5. #5
    Registered User
    Join Date
    08-14-2017
    Location
    Liverpool, England
    MS-Off Ver
    2016
    Posts
    21

    Re: How do I count and average only the number that corresponds with the adjacent string?

    I think I get what you mean, but I need it to be smart enough to pick out the numbers next to a certain string (bad area 1, bad area 2, etc.) i.e. if there were more "bad area 3" rows with Potent.Con.Cnum numbers, it would count and average the right numbers in the third column.

    Does that make sense?

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How do I count and average only the number that corresponds with the adjacent string?

    See change to you example file.

    Formula fixed to use rows 2 to 10000
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-14-2017
    Location
    Liverpool, England
    MS-Off Ver
    2016
    Posts
    21

    Re: How do I count and average only the number that corresponds with the adjacent string?

    Thanks pal.

+ 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] Average column if adjacent cells are between a specific number range
    By Madtaxi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2017, 08:56 PM
  2. [SOLVED] count duplicated string in Range for each letter,Non Adjacent Row
    By david gonzalez in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-25-2014, 04:00 PM
  3. [SOLVED] Specific character (Y/N ) corresponds to a number in adjacent row
    By kleos in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-21-2013, 05:04 AM
  4. Lookup for Code that Corresponds to Part of string of text in a Cell
    By brandnew22 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 07:33 PM
  5. Replies: 1
    Last Post: 02-09-2012, 05:13 PM
  6. Replies: 4
    Last Post: 01-13-2012, 07:39 AM
  7. count number of instances of string in a string
    By lawrencef in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2008, 02:06 AM

Tags for this Thread

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