
Next: Showing "Meeting point" of lines in Cha.. 
Author 
Message 
rsilver External
Since: Nov 18, 2005 Posts: 5

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

Posted: 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.
=0sum(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

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

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

Posted: 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?) 


=0SUM(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 



