Gerneralising/autofilling an Equation

[MMcCann]

Hi guys, hope you can help me!

I need to calculate the following equation.

AreaXAccess = Sum of [ HomeIDbeds * AreaX:HomeIDTime^-2 ]
[
-------------------------------------------------- ]
[ Sum of AreaNpop *
AreaN:HomeIDTime^-2 ]


AreaX refers to the row for which Access is being calculated
AreaN refers to every other Area apart from Area X (all other rows)

There are 5022 Areas , and over 300 Homes

The spreadsheet is in the format

Column A = Area
Column B = AreaPop
C = HomeID (not in calculation)
D = Home id1 Beds (constant in all rows)
E = Area:Home id1 Time
F = Home id2 beds (constant in all rows)
G = Area:Home id2 Time

HIJKL will follow out for over 300 Home ID's

The rows will fill with 5022 areas, and the time between the area and each
home ( and the number of beds in that home).

I have done the following for 6 areas and 2 homes.

=(D2*(E2^-2))/((B3*(E3^-2)+(B4*(E4^-2))+(B5*(E5^-2))+(B6*(E6^-2))))+(F2*(G2^-2))/((B3*(G3^-2)+(B4*(G4^-2))+(B5*(G5^-2))+(B6*(G6^-2))))


But I was wondering is there a way to autofill this formula for 5022 and 300
homes, I don't want to type it by hand!

Thanks in advance,
M.

 

[MMcCann]

Sorry, that formula didn't appear properly , please read as


AreaXAccess =

[ HomeIDbeds * AreaX:HomeIDTime^-2]

Divided by

[ Sum of AreaNpop * AreaN:HomeIDTime^-2 ]

All summed