For instance if Cells A1=Snail, cell B2=Dog and cell A3=Snail and cells B1=100, B2=50 and B3=320 I would want a formula that only sums B1 and B3 together since they have the same exact text in the cell to their left. Can anyone help?