Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gerneralising/autofilling an Equation
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gerneralising/autofilling an Equation
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with autofilling formulas | New Users to Excel | |||
Autofilling information | Excel Worksheet Functions | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Autofilling data on a form | New Users to Excel | |||
autofilling cells | Excel Worksheet Functions |