+ Reply to Thread
Results 1 to 5 of 5

Summing number in Text?

  1. #1
    Registered User
    Join Date
    04-01-2008
    Location
    Houston
    MS-Off Ver
    Office 365
    Posts
    85

    Summing number in Text?

    Hi All,

    Much appreciated help needed. I've got a row of data that would like to sum the data that has the "S" in front. So, that's tricky enough for me to not know how to calculate. To make it even trickier I was hoping to only calculate "S" data that is prior to today. Attached example of what I’m trying to accomplish.

    Thanks!
    Cullen
    Attached Files Attached Files
    Last edited by Cullen8; 11-16-2012 at 03:04 PM.

  2. #2
    Registered User
    Join Date
    11-16-2012
    Location
    Crownpoint, New Mexico
    MS-Off Ver
    All.
    Posts
    59

    Re: Summing number in Text?

    This get it? Do reply.

    Thanks,
    Brandon
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-16-2012
    Location
    Crownpoint, New Mexico
    MS-Off Ver
    All.
    Posts
    59

    Re: Summing number in Text?

    On the sheet1(2) corrected the confusing static value of '8'. Not really an error on my part, the answer was on 'Sheet1' and the static value copied over when I made the new sheet.
    Attached Files Attached Files

  4. #4
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Summing number in Text?

    Use..

    Please Login or Register  to view this content.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  5. #5
    Registered User
    Join Date
    04-01-2008
    Location
    Houston
    MS-Off Ver
    Office 365
    Posts
    85

    Re: Summing number in Text?

    Thank you for you help, worked perfectly!

+ 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