Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: How to sum formulas with text?

  1. #1
    New Member
    Join Date
    Mar 2017
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #2
    Board Regular FDibbins's Avatar
    Join Date
    Feb 2013
    Location
    Duncansville, PA USA
    Posts
    6,176
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default 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

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    Regards

    Ford

  3. #3
    Board Regular
    Join Date
    Oct 2013
    Location
    Lakeland, FL USA
    Posts
    352
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to sum formulas with text?

    I think the "abc" is in the cell

    =A3&" "&F3*G3

  4. #4
    Board Regular FDibbins's Avatar
    Join Date
    Feb 2013
    Location
    Duncansville, PA USA
    Posts
    6,176
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to sum formulas with text?

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

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

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    Regards

    Ford

  5. #5
    Board Regular
    Join Date
    Oct 2013
    Location
    Lakeland, FL USA
    Posts
    352
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to sum formulas with text?

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

  6. #6
    New Member
    Join Date
    Mar 2017
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #7
    Board Regular FDibbins's Avatar
    Join Date
    Feb 2013
    Location
    Duncansville, PA USA
    Posts
    6,176
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default 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

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    Regards

    Ford

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com