=SUM(IF(A1:A200,A1:A20))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wonderland" wrote in message
...
I'm building a rather complex spreadsheet with various links and basically
I
want any results from SUM functions not to go into negative numbers. Any
results that should be negative I would like to be zeroed