How do I sum cells and ignore text - Page 2
Excel VBA Tools from Andrew
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: How do I sum cells and ignore text

  1. #11
    New Member
    Join Date
    Oct 2014
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How do I sum cells and ignore text

     
    A1 = 10 Runs
    A2 = 10
    A3 = NO RUN
    A4 = -15 Points

    What will be the sum of A1:A4 , my answer would be 5
    Please suggest a formula which will extract 10 from " 10 Runs " , No Run as 0 Value , and -15

    Thanks & Regards

    Salman

  2. #12
    New Member
    Join Date
    Nov 2017
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How do I sum cells and ignore text

      
    I used the formula below in a schedule I am creating. The schedule reads (Time Out - Time In) - (Lunch out - Lunch in) to give me a total number hours worked for each employee. The schedule is on one tab and the data is on another. I was originally getting the ### error if the cells were blank (person not working that day). When I sum all the hours worked for that person, that month, It looked like the sum was correct, I was getting a number close but not correct. It was deducting 30 minutes from each cell that had the error. I used the formula below which corrected the ### error and sums correctly however, it does not subtract the lunch break. My current formula before attempting the one below is. =(DECEMBER!N8-DECEMBER!M8)-(DECEMBER!$AB$7-DECEMBER!$AA$7). I need to know how to adapt the new formula =IF(AND(ISNUMBER(DECEMBER!K6),ISNUMBER(DECEMBER!J6)),DECEMBER!K6-DECEMBER!J6,"") to also subtract the lunch break
    ___________________________________________________
    Quote Originally Posted by VoG View Post
    Use a formula like

    =IF(AND(ISNUMBER(F1),ISNUMBER(G1)),F1*G1,"")

    which will leave the result cell blank if either of the values that you are trying to multiply is non-numeric.

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