Trying to change a formula

[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?

thanks

--

 

[Pete_UK]

This is an array formula - did you remember to commit the formula with
CTRL-SHIFT-ENTER (CSE) when you amended it? Double-click in the cell as
if to edit it, then do CTRL-SHIFT-ENTER.

Hope this helps.

Pete

 

[S S]

I think thats the problem Pete I seem to remember there was something a
little different on how I should enter it.

thanks.

 

[S S]

The formula below has now been changed and now works (thanks Pete), I have
the same formula for columns H, I J K but dragging it across doesnt work it
just appears to copy it with the same references as in column G.

help
thanks

 

[Pete_UK]

Glad to be of help.

Pete

I think thats the problem Pete I seem to remember there was something a
little different on how I should enter it.

thanks.