Subtotal formulas that chooses values
 

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


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=504527

Subtotal formulas that chooses values
 

mikeburg,
In I5 use:

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

Then copy down.

HTH
Kostis Vezerides

Subtotal formulas that chooses values
 

Works great! Many thanks, mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=504527