Avg Ifs

Msamples76711

Hello, I'm trying to use an Avg Ifs formula to calculate the average based on multiple criteria. The Avg if formula available captures a singular criteria. Is there another formula in smartsheet that I can use to avg based on multiple criteria? Thanks!

Mihai Nedelcu

@Msamples76711 - I had the same problem and I solved it with this -> https://community.smartsheet.com/discussion/87512/average-ifs-formula

Jeff Reisman

@Msamples76711 If you can share a bit more about what your use case and what kind of criteria you have, there may be several ways to do what you want by combining AVG or AVERAGEIF with other functions.

Mihai Nedelcu

@Msamples76711 - I had the same problem and I solved it with this -> https://community.smartsheet.com/discussion/87512/average-ifs-formula

Msamples76711

@Mihai Nedelcu thank you for that link! This worked!