LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
weighted average in pivot table nasser Excel Discussion (Misc queries) 3 January 18th 06 04:36 PM
calculating a weighted average using formula bob green Excel Worksheet Functions 1 August 1st 05 10:33 PM
calculating a weighted average uisng formula bob green Excel Worksheet Functions 1 August 1st 05 06:31 AM
Can you calculate "weighted average cost of capital? Dennis Excel Discussion (Misc queries) 1 June 20th 05 07:33 AM
Show weighted average value after filter. BillC Excel Worksheet Functions 3 May 3rd 05 04:13 PM


All times are GMT +1. The time now is 08:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"