Try the following
=AVERAGE(IF(C387:c566=0,"",C387:c566))

=STDEV(IF(C387:c566=0,"",C387:c566))

for both the formulae, press control + shift + enter as they are array
formulae

- Mangesh



"Sam" wrote in message
...
I know that one can compute the average of nonzero entries in column C by
using the formula C378=SUM(C387:C566)/(COUNTIF(C387:C566,"0")).
However, how can one compute the standard deviation of nonzero entries in
the range C387:c566?


Thank you for any help that you may be able to give.