Array formula with array constant

[Fdjaynes]

I need help with creating an array formula for a spreadsheet I'm developing. The percentages are constants. In the calculated total column I want the sum of 100%*10 + 88%*20 + 68%*29 + 50%*15 + 20%*6 for each line. Any help or guidance will be greatly appreciated. - Fred

	100%	88%	68%	50%	20%	Calculated Total
1	10	20	29	15	6
2	30	30	0	0	20
3	150	0	0	0	10
4	500	0	100	120

<tbody>
</tbody>

 

[RoryA]

Not one cell for 5 different constants, no. You could use 5 cells in a row somewhere else or, if you really want to use a constant, you could use this:

=SUMPRODUCT($A2:$E2,{1,0.88,0.68,0.5,0.2},{10,20,29,15,6})

 

[Tetra201]

Instead of inserting a row can you reference a cell for the constant?

As I suggested in Post #8, you can create a name, say, _Pct, that refers to ={1,0.88,0.68,0.5,0.2}.
Then, you can use this formula:

=SUMPRODUCT($A1:$E1,_Pct)

 

[Fdjaynes]

Thanks so much for the help. I'll be back for more I'm sure.

Fred