I guess I was concerned because the word "average" is not in the formula

"Dave O" wrote:

=SUMIF(L5:L25000,"2",L5:L25000)/COUNTIF(L5:L25000,"2") generates a
simple average.