On way:

=PRODUCT(IF(A1:A5=0,1,A1:A5))

Array entered.

--
Jim
"Steve" wrote in message
...
| I'm a pretty savvy excel user but am at a loss to how to do this, I'm
| embarrassed to say. I have a column of numbers and want to multiply all
of
| the non-zero numbers. For example, if the column is:
|
| 1.056
| .9978
| .795
| 0
| 0
| .256
|
| The answer would be .21444430233 (1.056 * .9978 * .795 * .256). I want a
| formula that would work for any column of numbers. Thanks for any help.