Forum Discussion
Using AveragerIFS with multiple criteria
I have used the AverageIFS to get the average of a data set within certain parameters and with set criteria. I am trying to add to that since the criteria has change mid stream. So, instead of using 2 formulas and use weighted average. I am trying to combine them into one formula. Not sure if it can be done, but I am looking to see if anyone has done anything like this.
skabilly I'm assuming the weighted average formula =(($D26*F26)+($D27*F27))/$D28) refers to the cells where the averageifs formulas are located ($D26 and $D27) and cells with corresponding countifs (F26 and F27) to create proper weighted average. if that is the case you could create a single large formula by replacing those cell refs with the actual formula you listed earlier. If instead you are trying to have a single averageifs with OR condition inside, I don't think that will work. But you could simplify your formulas using sumifs and then divide by the that total ($D28) instead of averageifs and then multiply by the count since that is just going back to the sum anyway.