Cutter, that's exactly what I want! Only is there anyway not to have to type
a "-" before every withdrawal? There are way more withdrawals that deposits.
I just asked a question on the board inquiring whether there is such a thing
as the opposite of the sum function, but i'm pretty sure i made absolutely no
sense whatsoever and no one will respond.
But you have hit the nail on the head, and seem to know what I am trying to
do. I just don't want to have to remember to make what wil be essentially
EVERY number a negative one. It really slows down the data entry, if you know
what I mean.....
Thanks!
"Cutter" wrote:
It sounds like you just want to sum the cells from row 3 to that 'really
big number'.
In C2 type: =SUM(C3:C65536)
Bear in mind that you'll have to make sure that you enter expenditures
as negative numbers and deposits as positives.
--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=486463