SUMPRODUCT with non continuous ranges

[a massive zebra]

Hi,

I would like to multiply the values in cells F22, F39 and F48 by the corresponding values in column J. I thought the following formula should work, but it is not being accepted by excel.

=SUMPRODUCT(({F22,F39,F48}),({J22,J39,J48}))

Is it possible to use SUMPRODUCT with non continuous ranges? If so, what is the correct syntax?

Thanks

 

[GerryZ]

Hello
I like this question but I don't understand all of the issue It was nice to see a spreadsheet sample instead to use 100s of words and formulas
Can you post a screenshot with just few rows and colunms with the expected outcome so we can understand better?
help us to help you
Thank you in advance!

 

[Aladin Akyurek]

Hi,

I would like to multiply the values in cells F22, F39 and F48 by the corresponding values in column J. I thought the following formula should work, but it is not being accepted by excel.

=SUMPRODUCT(({F22,F39,F48}),({J22,J39,J48}))

Is it possible to use SUMPRODUCT with non continuous ranges? If so, what is the correct syntax?

Thanks

Try...

=SUMPRODUCT(CHOOSE({1,2,3},F22,F39,F48),CHOOSE({1,2,3},J22,J39,J48))

 

[a massive zebra]

Try...

=SUMPRODUCT(CHOOSE({1,2,3},F22,F39,F48),CHOOSE({1,2,3},J22,J39,J48))

Great, that worked perfectly.

Thanks Aladin.

 

[Aladin Akyurek]

Great, that worked perfectly.

Thanks Aladin.

You are welcome.

 

[GerryZ]

Hello Aladin
I'm Learning a lot from you but this time i really didn't understand
can you post a sample! because in this case I didn't see the table and is not so easy
thank you!

 

[Aladin Akyurek]

Hello Aladin
I'm Learning a lot from you but this time i really didn't understand
can you post a sample! because in this case I didn't see the table and is not so easy
thank you!

No need for an exhibit actually. Try to enter numbers in the cells the OP has indicated and then run the formula.

 

[gaz_chops]

I don't understand why not simply use?
=SUM(F2*J2)+(F9*J9)+(F15*J15)