Consulting

Results 1 to 3 of 3

Thread: Sum problem help for a novice

  1. #1
    VBAX Tutor
    Joined
    Jul 2009
    Posts
    207
    Location

    Sum problem help for a novice

    Hello

    I have a formula in column G cells which looks at column A cells and if the condition is met it copies column B into G.
    That formula works

    I then want to sum total column G without taking out the text ie 'mins' so in my example I would have a result of 140 mins.

    Is that possible

    or

    How could I modify my working formula to just copy and paste the numeric and ignore the text.

    Both answers would help me better understand



    Please see my example w/s attached.
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    See comments in attached.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Tutor
    Joined
    Jul 2009
    Posts
    207
    Location
    Thank you p45cal, I will need to study your comments.

Posting Permissions

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