Correct. Any number that is 2 or less will not be involved in the calculation.

"Kathy" wrote:

Thank you for your help - just to double check this gives me an average of
the numbers greater than 2?

"Elkar" wrote:

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