Results 1 to 4 of 4

Using Sumproduct to calculate weighted average

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-16-2014
    Location
    Columbia, Maryland
    MS-Off Ver
    2013
    Posts
    134

    Using Sumproduct to calculate weighted average

    So I have a bond portfolio made up of bond funds and treasuries. I have broken out for the bond funds what portion of their portfolios are attributable to Government bonds, Corporate bonds, Asset backed bonds etc. Now each bond obviously makes up a certain weight in the portfolio. What I'm trying to do is calculate the weighted average percentage of Government bonds, Corporate bonds, Asset backed bonds etc for the entire portfolio based on each bond funds weighting in the portfolio. I've attached what I have so far, I just would like to know if I've done it correctly or if I'm missing something. Any help in clarifying this would be greatly appreciated The column "N" is where I have the weighted average calculation that I need help with.

    Cheers!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. sumproduct function for weighted average
    By copperdog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2014, 10:18 PM
  2. Replies: 6
    Last Post: 11-25-2013, 08:35 PM
  3. Weighted Average IF (sumproduct conditional)
    By Leopold2000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2013, 03:27 PM
  4. [SOLVED] Help with IF and SUMPRODUCT to calculate weighted average??
    By consulttk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2012, 03:56 PM
  5. SUMPRODUCT Issue - Need to calculate weighted average of multiple ranges
    By arcobalt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2012, 04:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1