You could create another column of data that read's the column you wish
to average like this {=if(A2=0,"",A2). This will effectively replace
the zeros with blanks, which are not included as zero values in an
average. Then you can change the column you wish to average with the
new column.

There'd be a myriad of more complicated and VBA-involved solutions, but
this is quick and easy.


--
Excel_Geek
------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=396927