Try this:

=SUMIF(L5:L25000,"2")/COUNTIF(L5:L25000,"2")

HTH,
Elkar


"Kathy" wrote:

Could someone please help me write a formula to obtain and average of
L5:L25000 of numbers greater than 2??

thanks,
Kathy