Daverage function with rows instead of colums.

D

Dave

I need to calculate a weekly moving average of prices by leverage from
information from a another sheet. An example of the sheet is below:

Deal Co. A Co.B Co.C
Week 1 1 3
Leverage Pricing
5.0x - 200 300
4.5x 250 125 400
4.0x 350 - 500

I need to create a table on another sheet that will calc. the weekly average
price of each Leverage level. The new table looks like this:

Leverage Average Price (wk1) Avg Price (wk2)
5.0x
4.5x
4.0x

Can anyone help? Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup with to parameters 3
URGENT - Help with choice of formula 2
Pricing from a table based on dimesions in 2 differnt cells (Excel 3
Average of the Product of Two Columns 0
newbie: manipulating cols & rows in named range 3
Calculate Monthly Average Multiplied by Count of Dates/Month with Multiple Records Having Same Date 2
Mutual Fund Problem 2
Lots of Frustration - Lots of Arrays, Dynamic Ranges Don't Work, Help With Options 6

Top