+ Reply to Thread
Results 1 to 4 of 4

Weighted Averages an multiple columns

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Weighted Averages an multiple columns

    I have tried uploading the worksheet and it won't let me for whatever reason so I will try to be as clear as possible.
    I have the following formula to give me a weighted average.
    =SUMPRODUCT(A8:A14,B8:B14)/SUM(B8:B14)

    I also have data in E8:E14,F8:F18 which has its own weighted average formula that it covers, and the same for
    I8:I18,J8:J18. What I want to do is to write a formula that will give me one large weighted average that encompasses all of these data fields.

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Weighted Averages an multiple columns

    Can you do something like this?

    =(SUMPRODUCT(A8:A14,B8:B14)+SUMPRODUCT(E8:E14,F8:F14)+SUMPRODUCT(I8:I14,J8:J14))/SUM(B8:B14,F8:F14,J8:J14)

  3. #3
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Weighted Averages an multiple columns

    That worked without any errors, as far as I can tell that is the right formula then. Thank you.

  4. #4
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Weighted Averages an multiple columns

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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