Multiply 2 cells separated with comma

Hi,
Is there's any way to calculate 2 cells separate with comma,
attached is the detail. thank you very much.

Value1 are variable: 0,0,3,6,4,2,0,0,0,0
Value2 are fix: 5,15,25,35,45,55,65,75,85,95

i want to multiply those 2 cells:
=SUM((0*5),(0*15),(3*25),(6*35),(4*45),(2*55),(0*65),(0*75),(0*85),(0*95))

BR//

Are there one-figures always in the first cell?

if so
=SUM(IFERROR(MID(A2,ROW(1:19),1)*ROW(1:19)*5,)) as array formula

Expanding https://stackoverflow.com/questions/...-array-formula

the following is an non array answer!

Please Login or Register  to view this content.

Hi tim201110,
Thank you very much for the feedback, ya thats for array formula.

Hi davsth,
thank a lot for your feedback / formula as per my expectation for non array.

BR//

Dear all,
once more,
do you know formula if i want to sum value1
sample
Value1 are variable:
0,0,3,6,4,2,0,0,0,0 --> 15
0,0,3,6,4,2,0,0,8,0 --> 23

BR//

sorry, just ignored my question.
got it...
=IF(ISBLANK(K3),0,SUMPRODUCT(MID(0&K3,LARGE(INDEX(ISNUMBER(--MID(K3,ROW(OFFSET(K3,,,LEN(K3)))-ROW(K3)+1,1))*(ROW(OFFSET(K3,,,LEN(K3)))-ROW(K3)+1),0),ROW(OFFSET(K3,,,LEN(K3)))-ROW(K3)+1)+1,1)*1))

Hi Alkey,
but seem still uncorrect if my variable value:
14,1,0,0,0,0,0,0,0,0
0,3,11,0,1,0,0,0,0,0
15,0,0,0,0,0,0,0,0,0
14,0,1,0,0,0,0,0,0,0

BR//