Getting an average between a number range

[schugh]

I have a column that stores hours that are worked on a job, they can range from between 0 hours and 15 hours, i want to be able to run anverage on this column but for it only to do the average for numbers greater than 0 and less than 10.................any ideas please?

 

[Gary's Student]

For data in A1 thru A27:

6
8
9
2
10
5
15
2
8
7
12
0
13
9
11
14
2
1
5
9
15
14
9
11
15
15
12

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

=SUMPRODUCT(--(A1:A27>0)*(A1:A27<10)*(A1:A27))/SUMPRODUCT(--(A1:A27>0)*(A1:A27<10))

will display:

5.857143

<tbody>
</tbody>

 

[schugh]

Thank you......works a treat!!