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
|