Hi,

Try;

=IF(SUM(xx)<0,0,SUM(xx))

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"peerless" wrote:

If a number of cells add up to a minus figure how do i show this as not being
a mius ie any number sum = to a minus would be 0