SUMPRODUCT including range and static values within

[mike212]

A basic sumproduct might look something like this with range a1:a3 and b1:b3. I'd like to do a variation of this where instead I reference a range for the first part but then substitute in static values for the second part (the b1:b3 part).

If I want to substitute in the array of values 3,2,1 then my guess to how this would look is:
=SUMPRODUCT(A1:A3,{3,2,1})
Based on the #VALUE! error I can see that my syntax is wrong if this is even possible. Google just leads me down the path of array formulas which isn't what I want. The result of the formula isn't an array, just an input. Is it possible to do what I want to do?

 

[Dave Patton]

try the following Since you have 365, the sum may be what you require,

SumProduct2022.xlsm
	A	B
1	10	3
2	20	2
3	30	1
4
5	100
6	100
7	100
8
6b

Cell Formulas
Range	Formula
A5	A5	=SUMPRODUCT(A1:A3,B1:B3)
A6	A6	=SUMPRODUCT(A1:A3,{3;2;1})
A7	A7	=SUM(A1:A3*{3;2;1})

 

[SanjayGMusafir]

=SUMPRODUCT(A1:A3,{3;2;1})

I was thinking where Mike was doing wrong and I was trying so many permutations. Now I realize where the error was.

Thanks Dave

 

[mike212]

try the following Since you have 365, the sum may be what you require,

Thanks!

 

[Dave Patton]

Thanks for the feedback.