# 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.  Register To Reply

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

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

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

Will give it a shot. Thanks  Register To Reply

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.....  Register To Reply

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

I have it working now. Thanks for the help.  Register To Reply