S
S S
This is the formula I am using and it works good....
=SUM(IF(ISERR(FIND("-",G15:G125)),,REPLACE(G15:G125,1,FIND("-",G15:G125),"")-LEFT(G15:G125,FIND("-",G15:G125)-1)+1))
I now need to extend down to cell G133 instead of G125
I have manually changed all the G125s to G133 but then it returns a zero
What am I doing wrong?
Also I am using the above formula for rows A -G can I just drag the formula
across ? as I seem to remember in the past this didnt work.
thanks
--
=SUM(IF(ISERR(FIND("-",G15:G125)),,REPLACE(G15:G125,1,FIND("-",G15:G125),"")-LEFT(G15:G125,FIND("-",G15:G125)-1)+1))
I now need to extend down to cell G133 instead of G125
I have manually changed all the G125s to G133 but then it returns a zero
What am I doing wrong?
Also I am using the above formula for rows A -G can I just drag the formula
across ? as I seem to remember in the past this didnt work.
thanks
--