Sum function

Omi · Nov 3, 2003

Hi,

If I have a set of numbers , how can I ask Excell to give
me the the sum of all +ve and sum of all -Ve

Example

-1
2
5
-6
7
-10

Answer: Sum of all +ve is 14, sum of all -VE is -17

Thanks
omer

Bob Phillips · Nov 3, 2003

Omi,

=SUMIF(A1:A10,"<"&0)

and

=SUMIF(A1:A10,">"&0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)