Thanks:  0
Likes:  0

# Thread: How to sum formulas with text?

1. ## How to sum formulas with text?

Hello, trying to add formulas with text
Cell1 ="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???

2. ## Re: How to sum formulas with text?

Hi, welcome to the forum

I have a feeling your sample is way too simple compared to what you have?

Based on what you showed, why not just...
=F3*G3*2
?

also, you don't need to use SUM when multiplying 2 numbers together...
="abc "&F3*G3

3. ## Re: How to sum formulas with text?

I think the "abc" is in the cell

=A3&" "&F3*G3

4. ## Re: How to sum formulas with text?

Originally Posted by AlKey
I think the "abc" is in the cell

=A3&" "&F3*G3
probably, that's why I said I thought the sample was overly simple

5. ## Re: How to sum formulas with text?

Originally Posted by FDibbins
probably, that's why I said I thought the sample was overly simple
It just couldn't be simpler than that

6. ## Re: How to sum formulas with text?

Ok guys. I am rephrasing this example. Sorry i was not more clear.
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.

7. ## Re: How to sum formulas with text?

1st post...
Cell1 ="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???
2nd post
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.
All you did was change abc to cat and dog, still does not explain what you are trying to do. You need to provide realistic sample data, as well as what your expected outcome would be.

Remember, what you are doing is obvious to you, but we have no clue what you are doing

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•