+ Reply to Thread
Results 1 to 5 of 5

Calculate a weighted average in a single cell based on multiple criteria

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    South Carolina
    MS-Off Ver
    Excel 2010
    Posts
    6

    Calculate a weighted average in a single cell based on multiple criteria

    Hey, I was wondering if someone could help me figure this out. I'm trying to calculate a weighted average, but the two arrays need to be formulated after meeting specific criteria.

    In the attached spreadsheet. I want to calculate the weighted average where Class 1 = 1 and Class 2 = 2. This is a simplified version because my list is much longer and has a total of 4 criteria. I'm trying to avoid pivot tables and sorting data. I just want a single formula that can dig into the ranges and spit out the answer.

    Thanks for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Calculate a weighted average in a single cell based on multiple criteria

    Try
    Please Login or Register  to view this content.
    Last edited by Ace_XL; 02-14-2013 at 03:31 PM.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    02-14-2013
    Location
    South Carolina
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Calculate a weighted average in a single cell based on multiple criteria

    Will give it a shot. Thanks

  4. #4
    Registered User
    Join Date
    02-14-2013
    Location
    South Carolina
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Calculate a weighted average in a single cell based on multiple criteria

    For some reason I could not apply that to my spreadsheet (it works on the simple spreadsheet). I have 5 criteria. I wonder if there is a limit on the # of criteria. I also named all of my ranges. Maybe I should double check that my named ranges are all the same length. Just did that, they all checked out. I can't even calculate the denominator. It gives a #value error. I guess I will try to complicate the basic sheet and see at what point it blows up.....

  5. #5
    Registered User
    Join Date
    02-14-2013
    Location
    South Carolina
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Calculate a weighted average in a single cell based on multiple criteria

    I have it working now. Thanks for the help.

+ 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