Subtotal formulas that chooses values

[mikeburg]

Help. Need formulas to arive at subtotals in column I. For example row
5 is 1 times 4 (value on row 4 above the 1), row 6 is 1 times 2 (value
on row 4 above the 1), row 7 is 1 times 1 (value on row 4 above the 1),
row 8 is 1 times 3 (value of row 4 above line 1), etc


_|_D_|_E_|_F_|_G_|_H_|_I_
4|_1_|_2_|_3_|_4_|_5_|
5|___|___|___|_1_|___|_5_
6|___|_1_|___|___|___|_2_
7|_1_|___|___|___|___|_1_
8|___|___|_1_|___|___|_3_
Total Score 11

Thanks so very much. mikeburg

 

[vezerid]

mikeburg,
In I5 use:

=SUMPRODUCT($D$4:$H$4, D5:H5)

Then copy down.

HTH
Kostis Vezerides

 

[mikeburg]

Works great! Many thanks, mikeburg