creating a dynamic array formula

[radujit]

Hi Community! Need your help with this one
cell 1 =H7*H11
cell 2 =H7*I11+I7*H11
cell 3 =H7*J11+I7*I11+J7*H11
cell 4 =H7*K11+I7*J11+J7*I11+K7*H11
cell 5 =H7*L11+I7*K11+J7*J11+K7*I11+L7*H11
Considering that I have 60 such cells how can I put a nice array or another formula to populate with the same algorithm all the 60 cells

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)


MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Fluff]

It would have helped if you had replied to Peter, but if you have xl 365 how about

+Fluff 1.xlsm
	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
7	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
8
9
10
11	10	15	20	25	30	35	40	45	50	55	60	65	70	75	80	85	90
12
13	10	35	80	150	250	385	560	780	1050	1375	1760	2210	2730	3325	4000	4760	5610
Lists

Cell Formulas
Range	Formula
H13:X13	H13	=SUM((SORTBY($H7:H7,COLUMN($H7:H7),-1))*($H11:H11))