Sum
 

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

Sum
 

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

Sum
 

Hi

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

Andy.

"peerless" wrote in message
...
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

Sum
 

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

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


"Andy" wrote:

Hi

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

Andy.

"peerless" wrote in message
...
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