If your mixture of positive and negative values are stored in Column A, then

=SUMIF(A:A,"<0")

will return the sum of the negative numbers in this column.
--
Gary's Student


"JasonQ" wrote:


Hi,

I couldn't figure out how to write a certain equation, and I thought
you guys might be able to help me.

Here's my situation:

I have one column setup in my spreadsheet filled with many, many rows
of positive and negative numbers. What I want to do is have some box
over to the right of this immense column that lists the sum of all of
the negative numbers in the whole list, added together. Is this
possible to accomplish? If so, could someone give me pseudo code to do
it?

Thanks for your help,

Jason


--
JasonQ


------------------------------------------------------------------------
JasonQ's Profile: http://www.excelforum.com/member.php...o&userid=26014
View this thread: http://www.excelforum.com/showthread...hreadid=393696