[vox-tech] star office question

[Peter Jay Salzman]

concerning the spreadsheet...

how do you take the average of a range of cells, without taking any 0's into
account?

so if

A1  1
A2  1
A3  1
A4  1
A5  0

AVERAGE(A1:A5) yields 1.0, not .8.

thanks!
pete