I don't want the zero to show up because it is on a form that we print out
and some people fill it out by hand instead of on the computer.

"HKaplan" wrote:

Why the complicated formula?

=sum(F8:F26) will return 0 if F8:F26 is empty anyway. You don't need
to test for cells with data.