View Single Post
  #1   Report Post  
hawsoon13
 
Posts: n/a
Default Weighted Average

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...