PDA

View Full Version : Adding cells in column



John Davis
2011-10-18, 04:59 PM
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!312

John Davis
2011-10-18, 06:34 PM
Never mind, found another way