help with change to formula
 

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


--