Averageif function looking at a list criteria

I am trying to create an averagif formula that looks at a list of values in a cell. Currently if I do it the normal way it just returns back if this specific value is the only thing in the cell. But once there are multiple items in the cell it doesn't count that within its result.

Both formulas return the same way per what I've seen on various threads.


=AVERAGEIF({Resource Heatmap Range 1}, "AMRS", {Resource Heatmap Range 2})

=AVG(COLLECT({Resource Heatmap Range 2}, {Resource Heatmap Range 1}, @cell = "AMRS"))

Hopefully there is a way to average values based on a criteria that sits within a list on smartsheet.



Answers