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
2	0	588
3	0
4	0
5	588
6
7	0
8	0

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</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)