Help!

What function is the opposite of SUM?

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Excel General (archive) RSS
Next:  Showing "Meeting point" of lines in Cha..  
Author Message
rsilver
External


Since: Nov 18, 2005
Posts: 5



PostPosted: Sat Nov 19, 2005 12:05 pm    Post subject: What function is the opposite of SUM?
Archived from groups: microsoft>public>excel>misc (more info?)

A couple of questions below, I asked about how to make a cell show a running
balance (one cell, no matter how many entries you put into the column)

Reading through, it sounds like what I want is the opposite of the SUM
function, whatever that is.

If I understand correctly, the sum function ADDS all of the numbers in a
range. So, if I wanted to keep a running balance, I would simply make the
withdrawals negative number and the deposits postivie ones.

But, I have a LOT more withdrawals than deposits. Is there any way to tell
it to SUBTRACT all of the numbers in a column? This would mean that I would
get the same result as if I summed a bunch of postives (deposits) and
Negatives (withdrawals) only I would type in my withdrawals as positive
numbers and the deposits as negative numbers.

I just don't want to have to enter ever y withdrawal as a negative number.
there are so many, and I know I will keep missing the negative sign. I want
the numbers to be negative BY DEFAULT, so that only have to think about
signs if there is a deposit.

I know this makes no sense whatsoever. I'll try to think of a better way to
explain.....

I guess I am hoping that instead of entering a "-" in front of EVERY
withdrawal entry (ie almost all of the entries), I could tell it to do
opposite of SUM,

yeah,

okay I'll go now.

THanks!!!
Back to top
Dave Peterson
External


Since: Jul 08, 2005
Posts: 16264



PostPosted: Sat Nov 19, 2005 2:20 pm    Post subject: Re: What function is the opposite of SUM? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You could just add them using =Sum() and then subtract from 0.

=0-sum(b1:b10)
or
=-sum(b1:b10)






rsilver wrote:
>
> A couple of questions below, I asked about how to make a cell show a running
> balance (one cell, no matter how many entries you put into the column)
>
> Reading through, it sounds like what I want is the opposite of the SUM
> function, whatever that is.
>
> If I understand correctly, the sum function ADDS all of the numbers in a
> range. So, if I wanted to keep a running balance, I would simply make the
> withdrawals negative number and the deposits postivie ones.
>
> But, I have a LOT more withdrawals than deposits. Is there any way to tell
> it to SUBTRACT all of the numbers in a column? This would mean that I would
> get the same result as if I summed a bunch of postives (deposits) and
> Negatives (withdrawals) only I would type in my withdrawals as positive
> numbers and the deposits as negative numbers.
>
> I just don't want to have to enter ever y withdrawal as a negative number.
> there are so many, and I know I will keep missing the negative sign. I want
> the numbers to be negative BY DEFAULT, so that only have to think about
> signs if there is a deposit.
>
> I know this makes no sense whatsoever. I'll try to think of a better way to
> explain.....
>
> I guess I am hoping that instead of entering a "-" in front of EVERY
> withdrawal entry (ie almost all of the entries), I could tell it to do
> opposite of SUM,
>
> yeah,
>
> okay I'll go now.
>
> THanks!!!

--

Dave Peterson
Back to top
Bob Phillips
External


Since: Jun 08, 2004
Posts: 5103



PostPosted: Sat Nov 19, 2005 5:15 pm    Post subject: Re: What function is the opposite of SUM? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Simple

=SUM(A:A)-SUM(B:B)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rsilver" wrote in message

> A couple of questions below, I asked about how to make a cell show a
running
> balance (one cell, no matter how many entries you put into the column)
>
> Reading through, it sounds like what I want is the opposite of the SUM
> function, whatever that is.
>
> If I understand correctly, the sum function ADDS all of the numbers in a
> range. So, if I wanted to keep a running balance, I would simply make the
> withdrawals negative number and the deposits postivie ones.
>
> But, I have a LOT more withdrawals than deposits. Is there any way to tell
> it to SUBTRACT all of the numbers in a column? This would mean that I
would
> get the same result as if I summed a bunch of postives (deposits) and
> Negatives (withdrawals) only I would type in my withdrawals as positive
> numbers and the deposits as negative numbers.
>
> I just don't want to have to enter ever y withdrawal as a negative
number.
> there are so many, and I know I will keep missing the negative sign. I
want
> the numbers to be negative BY DEFAULT, so that only have to think about
> signs if there is a deposit.
>
> I know this makes no sense whatsoever. I'll try to think of a better way
to
> explain.....
>
> I guess I am hoping that instead of entering a "-" in front of EVERY
> withdrawal entry (ie almost all of the entries), I could tell it to do
> opposite of SUM,
>
> yeah,
>
> okay I'll go now.
>
> THanks!!!
Back to top
Niek Otten
External


Since: Feb 23, 2004
Posts: 1976



PostPosted: Sat Nov 19, 2005 5:15 pm    Post subject: Re: What function is the opposite of SUM? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

=-SUM()
Just a minus sign in front of the SUM

--
Kind regards,

Niek Otten

"rsilver" wrote in message

>A couple of questions below, I asked about how to make a cell show a
>running
> balance (one cell, no matter how many entries you put into the column)
>
> Reading through, it sounds like what I want is the opposite of the SUM
> function, whatever that is.
>
> If I understand correctly, the sum function ADDS all of the numbers in a
> range. So, if I wanted to keep a running balance, I would simply make the
> withdrawals negative number and the deposits postivie ones.
>
> But, I have a LOT more withdrawals than deposits. Is there any way to tell
> it to SUBTRACT all of the numbers in a column? This would mean that I
> would
> get the same result as if I summed a bunch of postives (deposits) and
> Negatives (withdrawals) only I would type in my withdrawals as positive
> numbers and the deposits as negative numbers.
>
> I just don't want to have to enter ever y withdrawal as a negative
> number.
> there are so many, and I know I will keep missing the negative sign. I
> want
> the numbers to be negative BY DEFAULT, so that only have to think about
> signs if there is a deposit.
>
> I know this makes no sense whatsoever. I'll try to think of a better way
> to
> explain.....
>
> I guess I am hoping that instead of entering a "-" in front of EVERY
> withdrawal entry (ie almost all of the entries), I could tell it to do
> opposite of SUM,
>
> yeah,
>
> okay I'll go now.
>
> THanks!!!
Back to top
rsilver
External


Since: Nov 18, 2005
Posts: 5



PostPosted: Sat Nov 19, 2005 5:15 pm    Post subject: Re: What function is the opposite of SUM? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

=0-SUM(A1:A10000)

Worked Perfectly!!!

Thanks!


"Niek Otten" wrote:

> =-SUM()
> Just a minus sign in front of the SUM
>
> --
> Kind regards,
>
> Niek Otten
>
> "rsilver" wrote in message
>
> >A couple of questions below, I asked about how to make a cell show a
> >running
> > balance (one cell, no matter how many entries you put into the column)
> >
> > Reading through, it sounds like what I want is the opposite of the SUM
> > function, whatever that is.
> >
> > If I understand correctly, the sum function ADDS all of the numbers in a
> > range. So, if I wanted to keep a running balance, I would simply make the
> > withdrawals negative number and the deposits postivie ones.
> >
> > But, I have a LOT more withdrawals than deposits. Is there any way to tell
> > it to SUBTRACT all of the numbers in a column? This would mean that I
> > would
> > get the same result as if I summed a bunch of postives (deposits) and
> > Negatives (withdrawals) only I would type in my withdrawals as positive
> > numbers and the deposits as negative numbers.
> >
> > I just don't want to have to enter ever y withdrawal as a negative
> > number.
> > there are so many, and I know I will keep missing the negative sign. I
> > want
> > the numbers to be negative BY DEFAULT, so that only have to think about
> > signs if there is a deposit.
> >
> > I know this makes no sense whatsoever. I'll try to think of a better way
> > to
> > explain.....
> >
> > I guess I am hoping that instead of entering a "-" in front of EVERY
> > withdrawal entry (ie almost all of the entries), I could tell it to do
> > opposite of SUM,
> >
> > yeah,
> >
> > okay I'll go now.
> >
> > THanks!!!
>
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Excel General (archive) All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum