Add negs, Add positives

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

I want to be able to sum only negative numbers ... then on another row, sum
the positive numbers but don't know how to do that unless I sort my ss, and
I don't want to because the negs and pos all relate to certain objects.

Thanks!
 
Annette, something like this, =SUMIF($A$1:$A$9,"<0"),
=SUMIF($A$1:$A$9,">0")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Hi Annette

use the SUMIF function
=SUMIF(A1:A10,"<"&0) for negative numbers
=SUMIF(A1:A10,">"&0) for positive numbers
where the numbers are in cells A1 to A10

Cheera
JulieD
 
Hi

=SUM((A1:A100)*(A1:A100>0))
=SUM((A1:A100)*(A1:A100<0))
both entered as array functions (Ctrl+Shift+Enter)


Arvi Laanemets
 
Sheesh ... you all have the same answer so I guess that means I have an
answer ... haha ... thanks for your quick responses and to tell you the
truth, it never dawned on me to use the < or > ... Thanks again!
 
Back
Top