+ Reply to Thread
Results 1 to 24 of 24

Excel 2007 : sum numbers in single cell

Hybrid View

  1. #1
    Registered User
    Join Date
    10-23-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: sum numbers in single cell

    =SUM(VALUE(MID(A1,ROW($A$1:OFFSET($A$1,LEN(A1)-1,0)),1)))

    This works perfectly for numbers in the cell. We can copy paste and get the result. Thanks.
    Last edited by Chandrasekhar Dash; 10-23-2013 at 11:36 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1