Formula help
 

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

thanks,
Kathy

Formula help
 

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

Formula help
 

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

Formula help
 

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

Formula help
 

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

Formula help
 

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

Formula help
 

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.

Formula help
 

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.