Non Zero Value from a range

[hsandeep]

Input Range C2:C8…ONLY 1 cell contains Non Zero value
Output in D2 as Non Zero Value from C2:C8
How to accomplish?
Thanks in advance
Sheet1

	C	D

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]588[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]588[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: right"]0[/TD]

</tbody>

 

[Joe4]

If only one has a value and the rest are blank or zero, you could simply SUM the range, i.e.
in cell D2:
=SUM(C2:C8)