How do I sum cells and ignore text - Page 2

Thanks:  0
Likes:  0

Thread: How do I sum cells and ignore text

1. 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. 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
___________________________________________________
Originally Posted by VoG
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

Posting Permissions

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