Results 1 to 2 of 2

Thread: Adding cells in column

  1. #1
    Seeker John Davis's Avatar
    Join Date
    Sep 2011
    Location
    Florida
    Posts
    8
    Articles
    0

    Question Adding cells in column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a list of reference numbers in a column with coordinating costs. Here is a similar example (full excel file attached):

    ____A____B_______C
    1__386___6.5____(=B1+B2)
    2__386___.86_______
    3__387___11.2___(=B3+B4+B5)
    4__387___2.3_______
    5__387___.90_______

    I need an equation that can recognize matching text in a column, then add the corresponding numbers in the next column over. There is no pattern to tell when only two need to be added, or three, or more.

    Another solution would be to filter out all the text that have 3 or more matches, leaving only the ones with two matches (like A1 and A2 in the above example) and from there adding them.

    Thanks in advance!excel help adding columns.xlsx
    Last edited by John Davis; 2011-10-18 at 04:02 PM.

  2. #2
    Seeker John Davis's Avatar
    Join Date
    Sep 2011
    Location
    Florida
    Posts
    8
    Articles
    0
    Never mind, found another way

Posting Permissions

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