Hello,

If I do a regular array, I would do something like:

{=SUM(A1:A5*B1:B5)}

to multiple a1*b1 + a2*b2, etc.

However, can i have a range like A1:A5, but then select individual
cells to multiply by?

For example,

{=SUM(A1:A5*D1,F5,G6,H8,I9)}

where a1*d1 + a2*f5 + a3*g6, etc