Hi KePaHa,

If the result of sum is 0( zero ), how to make the cell empty instead of
displaying 0


Clara
--
thank you so much for your help


"KePaHa" wrote:

Or =SUM(G2:G20) & IF(SUM(G2:G20)<=1, " Hour", " Hours")

"Gary''s Student" wrote:

=SUM(B2,20) & "Hour(s)"
--
Gary''s Student - gsnu200793