How do I do an Average of a field only if multiple criteria within a sheet are true?

kanderson_054 · 02/12/25

I noticed there is not an Averageifs formula in Smartsheet. How do you suggest I accomplish this?

VBAGuru · 02/12/25

I would suggest a SUMIFS divided by COUNTIFS

kanderson_054 · 02/13/25

Thanks. I will give that another try but didn't work the first time. Probably my user error writing the formula. 😊 Thanks again!

Paul Newcome · 02/13/25

You can also use an AVG/COLLECT combo.

=AVG(COLLECT({Range To Average}, {1st Criteria Range}, 1st criteria, {2nd Criteria Range}, 2nd criteria))

Answers