Sum

[peerless]

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

 

[Chris Marlow]

Hi,

Try;

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

Regards,

Chris.

 

[Guest]

Hi

Try this:
=MAX(SUM(A2:A20),0)

Andy.

 

[Chris Marlow]

That is more efficient ... does not do the sum twice.