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

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]100%[/TD]
[TD]88%[/TD]
[TD]68%[/TD]
[TD]50%[/TD]
[TD]20%[/TD]
[TD]Calculated Total[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]29[/TD]
[TD]15[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]150[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]500[/TD]
[TD]0[/TD]
[TD]100[/TD]
[TD]120[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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