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

2 way:

=AVERAGE(IF(A1:A1010,A1:A10))

(array-entered). Or

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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




.

Try the following array formula...

=AVERAGE(IF(A1:A810,A1:A8))

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

Hope this helps!

In article ,
"Jon" wrote:

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

A couple of ways

=AVERAGE(IF(A1:A1010,A1:A10))

entered with ctrl + shift & enter

or

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


Regards,

Peo Sjoblom

"Jon" wrote:

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

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

=AVERAGE(IF(H2:H1010,H2:H10))

--
Don Guillett
SalesAid Software

"Jon" wrote in message
...
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

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