Help in writing an Excel equation
 

Hi,

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

Here's my situation:

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

Thanks for your help,

Jaso

--
Jason

-----------------------------------------------------------------------
JasonQ's Profile: http://www.excelforum.com/member.php...fo&userid=2601
View this thread: http://www.excelforum.com/showthread.php?threadid=39369

Help in writing an Excel equation
 

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

Help in writing an Excel equation
 

sorry: is stored, not are stored.
--
Gary's Student


"Gary's Student" wrote:

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

Help in writing an Excel equation
 

Thanks for the help; that was exactly what I needed.

-Jason


--
JasonQ


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