Results 1 to 3 of 3

Thread: compare

  1. #1
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66

    Unanswered: compare

    Greetings,

    In the attached file, I like to compare the LIST in cell A against cell C and if there is a match, I want to take the number from COUNT column (cell D), copy into column B, and add them to get one total. What is the best way to accomplish this?
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2004
    Posts
    37

    Try This

    Paste this into cell B2 and drag it down to B12

    {=SUM(IF($C$2:$C$12=A2,$D$2:$D$12),0)}

    Hope this is what you wanted
    Mike

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. What about near matches? I.e. in column A you have "A & T " (which has two spaces at the end, as well as spaces between characters) and in Column C you have "A&T " (one space at the end, and no spaces between characters).

    This will affect your data integrity and results.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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