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