Help in writing an Excel equation

[JasonQ]

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

[Gary's Student]

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
>
>

[Gary's Student]

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
> >
> >

[JasonQ]

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

-Jason