View Single Post
  #1   Report Post  
Jon
 
Posts: n/a
Default AVERAGE problems

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