Sum Array Range & Individual Cells

  • Thread starter Thread starter Native
  • Start date Start date
N

Native

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
 
This is limited to 29 cells but works:

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