AVERAGE problems

[Jon]

I'm pretty new to Excell and I constantly have to browse
through the help section to figure out how to do use
different function. I couldn't find any answar to my
problem so I figured this is the place to ask.

I want to do an Average on a few columns, but I only want
the AVERAGE function to count data that is greatar than
10.

Let's say I have the following data:

45
76
8
2
789
34
98
3

Now, I only want an Average on the data greatar than 10.
Is there any function that will do this for me?

Thanks in advance

/Jon

 

[Jason Morin]

2 way:

=AVERAGE(IF(A1:A10>10,A1:A10))

(array-entered). Or

=SUMIF(A1:A10,">10")/COUNTIF(A1:A10,">10")

HTH
Jason
Atlanta, GA

 

[Domenic]

Try the following array formula...

=AVERAGE(IF(A1:A8>10,A1:A8))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

 

[Peo Sjoblom]

A couple of ways

=AVERAGE(IF(A1:A10>10,A1:A10))

entered with ctrl + shift & enter

or

=SUMIF(A1:A10,">10")/COUNTIF(A1:A10,">10")


Regards,

Peo Sjoblom

 

[Don Guillett]

this is an ARRAY formula so must be entered/edited with ctrl+shift+enter

=AVERAGE(IF(H2:H10>10,H2:H10))

 

[Guest]

The =SUMIF(B2:B28,">10")/COUNTIF(B2:B28,">10") did it.
Thanks a lot for the help!