Formula not working for me now
 

Regarding the 2 formulas below.They basically add up the amount of entries
in a column, for some reason one of them has stopped working.
Can someone help please.....thanks

correct formula (column K)......
=SUM(IF(ISERR(FIND("-",K15:K126)),,REPLACE(K15:K126,1,FIND("-",K15:K126),"")-LEFT(K15:K126,FIND("-",K15:K126)-1)+1))

Incorrect formula (column L)
=SUM(IF(ISERR(FIND("-",L15:L126)),,REPLACE(L15:L126,1,FIND("-",L15:L126),"")-LEFT(L15:L126,FIND("-",L15:L126)-1)+1))
This returns zero

I am using 10 columns C-L for some reason the `incorrect` formula reverted
to identical for column K and I manually changed all the Ks to Ls.

Any help appreciated.
thanks

Formula not working for me now
 

They look like an array formulas which require entering using the Ctrl+Shift
key sequence. Select the cell containing the formula that is not working and
enter edit mode by either double clicking the cell or clicking inside the
formula bar. Then hold down both the Ctrl key and Shift keys and hit Enter
(Ctrl + Shift + Enter).

Hope that helps.

Regards,
Greg

"S S" wrote:

Regarding the 2 formulas below.They basically add up the amount of entries
in a column, for some reason one of them has stopped working.
Can someone help please.....thanks

correct formula (column K)......
=SUM(IF(ISERR(FIND("-",K15:K126)),,REPLACE(K15:K126,1,FIND("-",K15:K126),"")-LEFT(K15:K126,FIND("-",K15:K126)-1)+1))

Incorrect formula (column L)
=SUM(IF(ISERR(FIND("-",L15:L126)),,REPLACE(L15:L126,1,FIND("-",L15:L126),"")-LEFT(L15:L126,FIND("-",L15:L126)-1)+1))
This returns zero

I am using 10 columns C-L for some reason the `incorrect` formula reverted
to identical for column K and I manually changed all the Ks to Ls.

Any help appreciated.
thanks

Formula not working for me now
 

Thanks that sorted it.



"Greg Wilson" wrote in message
...
They look like an array formulas which require entering using the
Ctrl+Shift
key sequence. Select the cell containing the formula that is not working
and
enter edit mode by either double clicking the cell or clicking inside the
formula bar. Then hold down both the Ctrl key and Shift keys and hit Enter
(Ctrl + Shift + Enter).

Hope that helps.

Regards,
Greg

"S S" wrote:

Regarding the 2 formulas below.They basically add up the amount of
entries
in a column, for some reason one of them has stopped working.
Can someone help please.....thanks

correct formula (column K)......
=SUM(IF(ISERR(FIND("-",K15:K126)),,REPLACE(K15:K126,1,FIND("-",K15:K126),"")-LEFT(K15:K126,FIND("-",K15:K126)-1)+1))

Incorrect formula (column L)
=SUM(IF(ISERR(FIND("-",L15:L126)),,REPLACE(L15:L126,1,FIND("-",L15:L126),"")-LEFT(L15:L126,FIND("-",L15:L126)-1)+1))
This returns zero

I am using 10 columns C-L for some reason the `incorrect` formula
reverted
to identical for column K and I manually changed all the Ks to Ls.

Any help appreciated.
thanks