Help with finding function/expression

[duncanp]

Running Windows7 and Excel 2010
I am trying to find a function/expression that I can insert into my first cell (A10) and click drag (horizontally) to fill out the cells to my final cell (say Z10)
e.g. see below

in cell A10: =A8*A4

in cell B10: =A8*B4+B8*A4

in cell C10: =A8*C4+B8*B4+C8*A4

in cell D10: =A8*D4+B8*C4+C8*B4+D8*A4
.
.
.
in cell Z10: =A8*Z4 +........... +Z8*A4

Many thanks

 

[p45cal]

Excel Workbook
	A	B	C	D	E	F	G	H	I
4	18	20	17	11	15	15	11	20	16
5
6
7
8	10	18	12	14	15	12	16	11	12
9
10	180	524	746	908	1102	1306	1497	1675	1927
11	180	524	746	908
Sheet11

row 11 contains the formulae you used, for comparison.
Drag A10 formula across.

 

[duncanp]

Excel Workbook
	A	B	C	D	E	F	G	H	I
4	18	20	17	11	15	15	11	20	16
5
6
7
8	10	18	12	14	15	12	16	11	12
9
10	180	524	746	908	1102	1306	1497	1675	1927
11	180	524	746	908
Sheet11

row 11 contains the formulae you used, for comparison.
Drag A10 formula across.

Hi just checked my post (Sunday evening) and seen your reply - this is great - many thanks. Sorry if this is late responding but I gave up looking on Friday evening and have only just checked.
Duncan