Trying to change a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S S - 05 Sep 2006 08:28 GMT

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

--

Reply to this Message

Pete_UK - 05 Sep 2006 09:39 GMT

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

> This is the formula I am using and it works good....
>
[quoted text clipped - 8 lines]
>
> --

Reply to this Message

S S - 05 Sep 2006 12:52 GMT

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

thanks.

> 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
[quoted text clipped - 16 lines]
>>
>> --

Reply to this Message

S S - 05 Sep 2006 13:28 GMT

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

>I think thats the problem Pete I seem to remember there was something a
>little different on how I should enter it.
[quoted text clipped - 20 lines]
>>>
>>> --

Reply to this Message

Pete_UK - 05 Sep 2006 14:32 GMT

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.
[quoted text clipped - 20 lines]
> >>
> >> --

Reply to this Message