-
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.
-
See comments in attached.
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.
-
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
-
Forum Rules