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

1. ## 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.

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

Try
``Please Login or Register  to view this content.``

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

Will give it a shot. Thanks

4. ## 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. ## Re: Calculate a weighted average in a single cell based on multiple criteria

I have it working now. Thanks for the help.

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

#### 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