probably, that's why I said I thought the sample was overly simple
2nd postCell1 ="abc "&(SUM(F3*G3))
Cell2 ="abc "&(SUM(F3*G3))
I want to add a formula here that will be able to extract the product from cell 1 and 2 and add them together.
Is this possible???
Cell1 ="Cat "&(SUM(B3*G3))
Cell2 ="Dog "&(SUM(H4*G4))
I want to add a formula in another cell that will be able to extract the product from cell 1 and 2 and add them together.