Need Formula HELP

[Sandi]

I have an Excel spreadsheet that has one column full of positive numbers and
negative numbers. I need a formula that will add up all the positive numbers
in one cell and all the negative numbers in another. I can do this by
selecting each cell one-by-one, but is there a faster way? It's a lot of
numbers to select one-by-one, that's why I am asking. THANKS :-)
--
Sandi Gardner

[Danny Lewis]

In the column next to it, (say the first value is in A3), so in B3, put
=if(A3>0,"x","y").

Run this formula to the bottom.

Then in a separate cell, write =sumif(B:B,"x",A:A)

That should work ok

Danny

"Sandi" wrote:

> I have an Excel spreadsheet that has one column full of positive numbers and
> negative numbers. I need a formula that will add up all the positive numbers
> in one cell and all the negative numbers in another. I can do this by
> selecting each cell one-by-one, but is there a faster way? It's a lot of
> numbers to select one-by-one, that's why I am asking. THANKS :-)
> --
> Sandi Gardner

[Danny Lewis]

Sorry and repeat the formula elsewhere for negative ie =SUMIF(B:B,"y",A:A)

"Sandi" wrote:

> I have an Excel spreadsheet that has one column full of positive numbers and
> negative numbers. I need a formula that will add up all the positive numbers
> in one cell and all the negative numbers in another. I can do this by
> selecting each cell one-by-one, but is there a faster way? It's a lot of
> numbers to select one-by-one, that's why I am asking. THANKS :-)
> --
> Sandi Gardner

[Arvi Laanemets]

Hi

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



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"Sandi" <Sandi@discussions.microsoft.com> wrote in message
news:3EE174EA-F0CC-423C-8F4C-06195B785A2A@microsoft.com...
>I have an Excel spreadsheet that has one column full of positive numbers
>and
> negative numbers. I need a formula that will add up all the positive
> numbers
> in one cell and all the negative numbers in another. I can do this by
> selecting each cell one-by-one, but is there a faster way? It's a lot of
> numbers to select one-by-one, that's why I am asking. THANKS :-)
> --
> Sandi Gardner

[Danny Lewis]

*steps back, sheepishly*

yes that's a little more simple....

"Arvi Laanemets" wrote:

> Hi
>
> =SUMIF(A:A,">0",A:A)
> =SUMIF(A:A,"<0",A:A)
>
>
>
> --
> Arvi Laanemets
> ( My real mail address: arvi.laanemets<at>tarkon.ee )
>
>
>
> "Sandi" <Sandi@discussions.microsoft.com> wrote in message
> news:3EE174EA-F0CC-423C-8F4C-06195B785A2A@microsoft.com...
> >I have an Excel spreadsheet that has one column full of positive numbers
> >and
> > negative numbers. I need a formula that will add up all the positive
> > numbers
> > in one cell and all the negative numbers in another. I can do this by
> > selecting each cell one-by-one, but is there a faster way? It's a lot of
> > numbers to select one-by-one, that's why I am asking. THANKS :-)
> > --
> > Sandi Gardner
>
>
>

[Sandi]

SUPER - worked like a charm!!!! Thanks so much!!!!!
--
Sandi Gardner


"Danny Lewis" wrote:

> Sorry and repeat the formula elsewhere for negative ie =SUMIF(B:B,"y",A:A)
>
> "Sandi" wrote:
>
> > I have an Excel spreadsheet that has one column full of positive numbers and
> > negative numbers. I need a formula that will add up all the positive numbers
> > in one cell and all the negative numbers in another. I can do this by
> > selecting each cell one-by-one, but is there a faster way? It's a lot of
> > numbers to select one-by-one, that's why I am asking. THANKS :-)
> > --
> > Sandi Gardner

[Sandi]

SUPER - worked like a charm!!!! Thanks so much!!!!!
--
Sandi Gardner


"Danny Lewis" wrote:

> Sorry and repeat the formula elsewhere for negative ie =SUMIF(B:B,"y",A:A)
>
> "Sandi" wrote:
>
> > I have an Excel spreadsheet that has one column full of positive numbers and
> > negative numbers. I need a formula that will add up all the positive numbers
> > in one cell and all the negative numbers in another. I can do this by
> > selecting each cell one-by-one, but is there a faster way? It's a lot of
> > numbers to select one-by-one, that's why I am asking. THANKS :-)
> > --
> > Sandi Gardner

[Sandi]

SUPER - worked like a charm!!!! Thanks so much!!!!!
--
Sandi Gardner


"Danny Lewis" wrote:

> Sorry and repeat the formula elsewhere for negative ie =SUMIF(B:B,"y",A:A)
>
> "Sandi" wrote:
>
> > I have an Excel spreadsheet that has one column full of positive numbers and
> > negative numbers. I need a formula that will add up all the positive numbers
> > in one cell and all the negative numbers in another. I can do this by
> > selecting each cell one-by-one, but is there a faster way? It's a lot of
> > numbers to select one-by-one, that's why I am asking. THANKS :-)
> > --
> > Sandi Gardner