Adding cells in column

John Davis

New member
Joined
Sep 30, 2011
Messages
8
Reaction score
0
Points
0
Location
Florida
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!View attachment excel help adding columns.xlsx
 
Last edited:
Back
Top