PDA

View Full Version : Sum problem help for a novice



Gil
07-30-2015, 06:11 AM
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.

p45cal
07-30-2015, 08:00 AM
See comments in attached.

Gil
07-30-2015, 08:49 AM
Thank you p45cal, I will need to study your comments.