C1: =SUM(IF(A1:B10,A1:B1))

D1: =SUM(IF(A1:B1<0,A1:B1))

which are both array formulae, so commit with Ctrl-Shift-Enter

--

HTH

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


"s.m.hardin" wrote in message
...


"s.m.hardin" wrote:

Is there a way I that excel can know when a number is positive or
negative
and put the correct sum in the correct coulumn? here is an example so
you know what I 'm asking. a1 has a positive number and b1 has a negative
number, but in c1 is were the positive answer goes and d1 is were the
nagative answer goes. Is there a certian formula that can do all that?