K
Kathy
Could someone please help me write a formula to obtain and average of
L5:L25000 of numbers greater than 2??
thanks,
Kathy
L5:L25000 of numbers greater than 2??
thanks,
Kathy
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Elkar
Try this:
=SUMIF(L5:L25000,">2")/COUNTIF(L5:L25000,">2")
HTH,
Elkar
=SUMIF(L5:L25000,">2")/COUNTIF(L5:L25000,">2")
HTH,
Elkar
D
Dave O
=SUMIF(L5:L25000,">2",L5:L25000)/COUNTIF(L5:L25000,">2") generates a
simple average.
simple average.
K
Kathy
Thank you for your help - just to double check this gives me an average of
the numbers greater than 2?
the numbers greater than 2?
E
Elkar
Correct. Any number that is 2 or less will not be involved in the calculation.
D
Dave O
Yes- if you'll note in the formula the numbers greater than 2 but not
equal to 2 are considered.
equal to 2 are considered.
K
Kathy
Thank you very much! Have a great day.
K
Kathy
I guess I was concerned because the word "average" is not in the formula