Results 1 to 4 of 4

Thread: Problem With Sum

  1. #1
    Seeker arup1032's Avatar
    Join Date
    Sep 2015
    Posts
    19
    Articles
    0
    Excel Version
    Excel 2013

    Problem With Sum



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello
    I am finding some problem with SUM. I sum up 2 values in cell like

    =38665+1783
    =36411+10119
    =36660+3549

    I Sum with using another formula like =CONCATENATE("=",I330,"+",J330) and the paste as value.

    After that the cell showing only =38665+1783

    Where I need to get the sum amount only. Like 40448

    Please help me.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,465
    Articles
    0
    Excel Version
    365
    =I330+J330
    or
    =SUM(I330,J330)
    or
    =SUM(I330:J330)

  3. #3
    Seeker arup1032's Avatar
    Join Date
    Sep 2015
    Posts
    19
    Articles
    0
    Excel Version
    Excel 2013
    p45cal I know that, But I need to use CONCATENATE. After CONCATENATE I will paste data as value. Then I need auto refresh. Because When I double click on the cell and press enter then the sum seems ok.

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,465
    Articles
    0
    Excel Version
    365
    I have no idea why you feel you have to use CONCATENATE.
    Perhaps you can write this first:
    =I330+J330
    then select all of I330 in the formula and press F9 on the keyboard, then select J330 in the formula and press F9 again, then press Enter.

Posting Permissions

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