Finding average ignoring zeros and not in a range

[tink]

How can you get an average of a group of numbers while ignoring zeros AND the numbers are not in a range. Like a3, a6, a8,a9 etc... How can you do this?

 

[Aladin Akyurek]

On 2002-03-02 12:30, tink wrote:
How can you get an average of a group of numbers while ignoring zeros AND the numbers are not in a range. Like a3, a6, a8,a9 etc... How can you do this?

=SUM(A1:A2,A4:A5,A7:A9)/MAX(1,COUNTIF(A1:A2,">0")+COUNTIF(A4:A5,">0")+COUNTIF(A7:A9,">0"))

will compute an average of positive numbers in non-consecutive ranges [ A1:A2,A4:A5,and A7:A9 ]ignoring zeroes in the process.

Aladin