How to sum formulas with text?

Jho0101

New Member
Joined
Mar 20, 2017
Messages
5
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???
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top