One mo
=if(count(e10:e20)=0,"",sum(e10:e20))


S S wrote:

Formula =SUM(E10:E20)
If there are no amounts in this column then the total displays 0
Is there a way to display the total cell as blank so that the 0 does not
appear.

thanks

--

--

Dave Peterson