Avg. Amount Based on Several Criteria



I am trying to write a formula that tells me the average repair amount based on several criteria in different columns on the sheet.

The columns are listed below:

Location Column

Repair Category Column

Repair Amount Column

Basically, if the location is "Location A" and the repair category is "Category 2" then what is the average repair amount in the Repair Amount column.

I've tried several attempts of countifs and contains formulas with no luck. I've used those successfully in the past for basic counts but I've never had to attempt an average as well.

I hope that makes sense! Thank you in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!