Sum Array Range & Individual Cells
 

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

Sum Array Range & Individual Cells
 

This is limited to 29 cells but works:

=SUMPRODUCT(A1:A5,CHOOSE({1;2;3;4;5},D1,F5,G6,H8,I 9))

--
Biff
Microsoft Excel MVP


"Native" wrote in message
...
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