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):


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