Adding positive and negative

's Computer Specifications

Is there a formula I can use to add up all the positive numbers and one to
add up all the negative ones?

's Computer Specifications

Hi,

=SUMIF(A1:A100,"<0")
and
=SUMIF(A1:A100,">0")

HTH
Cheers
Carim

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
adding positive and negative numbers	Coach O	Microsoft Excel Worksheet Functions	3	30th Dec 2008 03:53 AM
Adding Negative and Positive Numbers	Jacq	Microsoft Excel Misc	4	4th Dec 2007 07:00 PM
Adding only the negative or positive numers in a column or row	=?Utf-8?B?c2xvd2Vz?=	Microsoft Excel Misc	2	8th Nov 2006 05:14 AM
abs function not adding up - turning negative to positive	michael cu	Microsoft Access Queries	7	11th Nov 2003 10:39 PM
Adding negative and positive times	Chrisb	Microsoft Excel Worksheet Functions	1	14th Sep 2003 11:36 PM