# Thread: Average of values that meet a condition

1. ## Average of values that meet a condition

I want to calculate the average values in a column that meet a certain condition (i.e. >1).

What is the function or array that I should use to calculate the average (or any other statistical parameter)?

Thank you

Guillermo

2. ## Re: Average of values that meet a condition

If the values are in A1:A100, then use:

<pre>=SUMIF(A1:A100,">1",A1:A100)/COUNTIF(A1:A100,">1")
</pre>

3. ## Re: Average of values that meet a condition

Just what I needed .

Thank you!!!
<img src=/S/cool.gif border=0 alt=cool width=15 height=15>

4. ## Re: Average of values that meet a condition

Or, alternatively

=AVERAGE(IF(A1:A10>1,A1:A10)) entered as an array formula

+ Shorter
+ Allows multiple/nested conditions
- If used a lot, slows down recalculation
- Array entry i.e. Ctrl+Shift+Enter needs get used to

5. ## Re: Average of values that meet a condition

Excellent help!!!

My question was more oriented towards the use of arrays.

Thank you

Guillermo

<img src=/S/cool.gif border=0 alt=cool width=15 height=15>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•