Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to get some square footages...I have a series of lengths in one
column, and a series of widths in the next...I want to get an average width and multiply it by the sum of the lengths...the formula is roughly...(A1*B1)/Ax:(A28+B28)/Ax...where Ax is the sum of A1:A28 in this case...that formula obviously does not work...is there an easier way to enter this than to individually plug in every cell in a huge equation?...does this make any sense...thank you for any and all help... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
weighted average in pivot table | Excel Discussion (Misc queries) | |||
calculating a weighted average using formula | Excel Worksheet Functions | |||
calculating a weighted average uisng formula | Excel Worksheet Functions | |||
Can you calculate "weighted average cost of capital? | Excel Discussion (Misc queries) | |||
Show weighted average value after filter. | Excel Worksheet Functions |