H
Hendrik
Hi,
I have a few array formula's. I want to SUM the result from them in another
cell. But it always shows up as zero?
My formula in C18 and C19 etc.. :
=RIGHT(C18;LEN(C18)-MATCH(FALSE;ISERROR(1*MID(C18;ROW($1:$100);1));0)+1)
And my sum as usual.. =SUM(C18+C19)
I'm no big user of arrays. Is this some sort of limitation?
Thanks for any help!
I have a few array formula's. I want to SUM the result from them in another
cell. But it always shows up as zero?
My formula in C18 and C19 etc.. :
=RIGHT(C18;LEN(C18)-MATCH(FALSE;ISERROR(1*MID(C18;ROW($1:$100);1));0)+1)
And my sum as usual.. =SUM(C18+C19)
I'm no big user of arrays. Is this some sort of limitation?
Thanks for any help!