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

thanks,
Kathy

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

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

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

Yes- if you'll note in the formula the numbers greater than 2 but not
equal to 2 are considered.

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

Thank you very much! Have a great day.

"Dave O" wrote:

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

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.