# Multiply 2 cells separated with comma

1. ## 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//

2. ## Re: Multiply 2 cells separated with comma

Are there one-figures always in the first cell?

3. ## Re: Multiply 2 cells separated with comma

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

4. ## Re: Multiply 2 cells separated with comma

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

the following is an non array answer!

``Please Login or Register  to view this content.``

5. ## Re: Multiply 2 cells separated with comma

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//

6. ## Re: Multiply 2 cells separated with comma

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//

7. ## Re: Multiply 2 cells separated with comma

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))

8. ## Re: Multiply 2 cells separated with comma

For SUM non-array regular formula
Formula:
`Please Login or Register  to view this content.`

 v A B 1 0,0,3,6,4,2,0,0,0,0 15 2 0,0,3,6,4,2,0,0,8,0 23

9. ## Re: Multiply 2 cells separated with comma

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//

10. ## Re: Multiply 2 cells separated with comma

All your examples where for single digit separated by comma. For any other combination you would need an array formula

**Must be entered with Ctrl+Shift+Enter key combination.
Formula:
`Please Login or Register  to view this content.`

 v A B 1 0,0,3,6,4,2,0,0,0,0 15 2 0,0,3,6,4,2,0,0,8,0 23 3 14,1,0,0,0,0,0,0,0,0 15 4 0,3,11,0,1,0,0,0,0,0 15 5 15,0,0,0,0,0,0,0,0,0 15 6 14,0,1,0,0,0,0,0,0,0 15
If you want to multiply use this array formula
Formula:
`Please Login or Register  to view this content.`

 v A B 1 0,0,3,6,4,2,0,0,0,0 144 2 0,0,3,6,4,2,0,0,8,0 1152 3 14,1,0,0,0,0,0,0,0,0 14 4 0,3,11,0,1,0,0,0,0,0 33 5 15,0,0,0,0,0,0,0,0,0 15 6 14,0,1,0,0,0,0,0,0,0 14

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1