a massive zebra
Board Regular
- Joined
- Dec 1, 2009
- Messages
- 87
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
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