I need an averageifs formula but it seems as though that is not an option is there a work around?

Olivia Walton

I need the average of my survey results if the created date falls within a certain time period as well as if well as team participation. The following is subset of my data.

BullandKhmer

Why is this not an option? Why do you need a workaround? Why can you not use AVERAGEIF?

Olivia Walton

Olivia Walton

https://community.smartsheet.com/discussion/comment/427827#Comment_427827

I don't think that I can since its more than one criteria to be satisfied

BullandKhmer

OK Makes sense, try =AVG(COLLECT())