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