Hi
=IF(COUNT(G9:G17),SUM(G9:G17,-36),0)

or maybe
=MAX(0,SUM(G9:G17,-36))

--
Regards
Frank Kabel
Frankfurt, Germany
"Geo" schrieb im Newsbeitrag
...
In Cell G18 I have the formula =SUM(G9:G17,-36) but the cells G9-G17 are
blank yet G18 displays a -36 value. I know this must be simple but is
there a
way to get the G18 cell to display a "0" value if the cells G9-G17 are
blank?
--
Geo