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!