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.
Bookmarks