Count cells from a specific row and then take an average

spothier1

Hello all ,

What I am trying to do is look up a specific word in a column, then pull the value in the same row from another.. but then take an average of those numbers.

For example:

I want to know the average number of days for all CPSS, then average number of days for Internal etc.

Paul Newcome

I would suggest an AVG/COLLECT.

=AVG(COLLECT({Number Column}, {Instrument Column}, @cell = "Internal"))