+ Reply to Thread
Results 1 to 3 of 3

A formula to count adjacent cell values?

  1. #1
    Registered User
    Join Date
    09-30-2011
    Location
    Lithuania
    MS-Off Ver
    Excel 2010
    Posts
    81

    A formula to count adjacent cell values?

    I'm trying to count the values of cells when the adjacent cell has specific text. So, if column A has randomly repeating names and column B has random numbers 1-10, I'm looking to count the numbers that appear in column B next to each of the names.

    So far, I have this, but it's not working:

    Please Login or Register  to view this content.
    So, random names appear in column C. M2 has the name that I need to count. N2 has the formula in it. The values to be counted are in column B. Can anyone see where I'm doing this wrong?

    Thank you for any help anyone can offer!
    Last edited by Nate Westcott; 08-06-2012 at 10:15 PM.

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: A formula to count adjacent cell values?

    Count or sum? Column A or column C?

    =countif(A:A,M2)

    =sumif(A:A,M2,B:B)

  3. #3
    Registered User
    Join Date
    09-30-2011
    Location
    Lithuania
    MS-Off Ver
    Excel 2010
    Posts
    81

    Re: A formula to count adjacent cell values?

    Solved! Thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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