Averageifs Question

Daryl Lee
Daryl Lee ✭✭✭
edited 01/07/20 in Formulas and Functions


I am wanting to do an averageifs statement, but it does not seem that is supported. Is there another way that I can calculate an average based off fitting two different criteria?

Right now, I have this equation, which works for when just hitting the one criteria:

=ROUND(AVERAGEIF({System Request}, [Ticket Type 2]1, {Duration}), 2)

However, I also want to break down the average by month, which will add another average criteria.

I know that I can, if needed, create reports that break down the above criteria so I can just use the averageif based of months, but I would prefer to be able to just calculate this through an equation.

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!