Hello Everyone,

I need your assistance on a formula in Open Office Spread sheet.

I want to use below Excel formula in Open office Spread sheet. How do I use the same.

SUMPRODUCT(0+LEFT(A1:A4,MMULT(0+ISNUMBER(-MID(A1:A4,{1,2,3,4,5},1)),{1;1;1;1;1})))

This formula I am using to summing of Numerical part of Alphanumeric column.

4B

3456 A

1 BFD

8 BBB

With this formula I am getting a correct answer (4+3456+1+8=3469) in excel

The same output I am looking in Open Office.

Can you please assist me doing the same.

Regards, Bryan