| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating a weighted average in a pivot table
I have a data set that includes the IRR for each purchase my company has made. I am wanting to calculate a weighted average IRR for the year each purchase was made. I have tried writing a formula, however, the results are not what I expect. This is the current formula I have attempted... = SUM('Net IRR' *amt_face )/SUM(amt_face ) The results are too high. Thanks. -- mrogge ------------------------------------------------------------------------ mrogge's Profile: http://www.thecodecage.com/forumz/member.php?userid=238 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86830 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating a weighted average in a pivot table
Excel 2007
PivotTable, Table, GetPivotData, IRR http://www.mediafire.com/file/0mj3klznnij/04_16_09.xlsx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating weighted averages in a pivot table | Excel Discussion (Misc queries) | |||
| How do I calculate a weighted average in a pivot table? | Excel Discussion (Misc queries) | |||
| Weighted Average in Pivot table | Excel Worksheet Functions | |||
| weighted average on a pivot table | Excel Discussion (Misc queries) | |||
| weighted average in pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
