budget columns   

I need vertical columns automatically subtracting as entries are made with 
balance at the bottom, like so:

A is text budget items, B / C / &  D are Paycheck amounts.  As item amounts 
are entered, should auto subtract to balance cell farther down the column. 

I've tried all afternoon (actually it's 8:20pm now, so all day) to learn
how to do this, not succeeding.  Everything is beyond this & going left to 
right.
Those you know, please help.  I just want an easy home budget sheet, not a 
new career.  Thanks so much for any help at all.  My last math class was in 
1970.
-- 
household appliances should run themselves

date: Sat, 4 Oct 2008 20:26:01 -0700   author:   Jade

RE: budget columns   

Can you provide some sample data with the result you want?

"Jade" wrote:

> I need vertical columns automatically subtracting as entries are made with 
> balance at the bottom, like so:
> 
> A is text budget items, B / C / &  D are Paycheck amounts.  As item amounts 
> are entered, should auto subtract to balance cell farther down the column. 
> 
> I've tried all afternoon (actually it's 8:20pm now, so all day) to learn
> how to do this, not succeeding.  Everything is beyond this & going left to 
> right.
> Those you know, please help.  I just want an easy home budget sheet, not a 
> new career.  Thanks so much for any help at all.  My last math class was in 
> 1970.
> -- 
> household appliances should run themselves

date: Sun, 5 Oct 2008 18:49:00 -0700   author:   Sheeloo

Re: budget columns   

What version of Excel are you using?  There are some downloadable budget 
templates at Microsoft.com that might be easier than trying to roll your 
own; depending upon what exactly you're trying to do.

You want to SUBTRACT your paycheck amounts from something?  What is it 
that you want them to subtract from and why?

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007: 
http://tinyurl.com/5m3f5q



"Jade"  wrote in message 
news:50BFD1B1-2CD0-43B6-9AFB-7929D4D88769@microsoft.com:

> I need vertical columns automatically subtracting as entries are made with
> balance at the bottom, like so:
>
> A is text budget items, B / C / &  D are Paycheck amounts.  As item amounts
> are entered, should auto subtract to balance cell farther down the column.
>
> I've tried all afternoon (actually it's 8:20pm now, so all day) to learn
> how to do this, not succeeding.  Everything is beyond this & going left to
> right.
> Those you know, please help.  I just want an easy home budget sheet, not a
> new career.  Thanks so much for any help at all.  My last math class was in
> 1970.
> --
> household appliances should run themselves

date: Mon, 6 Oct 2008 02:48:44 +0000   author:   Ben M. Schorr - MVP (OneNote)

RE: budget columns   

Thanks so much for responding.  Templates I see are too overdone for my 
simple purposes and minimal time.   I'm wanting formula for this:

      Bills              Paycheck                 As each amount is filled 
in, column auto
                           1,000                     subtracts from the 
paycheck amount, so
rent                  __________              you always have your current 
balance at
hshld                __________              bottom of column. 
visa                  __________   
                                                       
Thank you for any help at all.
Jade.






-- 
household appliances should run themselves


"Jade" wrote:

> I need vertical columns automatically subtracting as entries are made with 
> balance at the bottom, like so:
> 
> A is text budget items, B / C / &  D are Paycheck amounts.  As item amounts 
> are entered, should auto subtract to balance cell farther down the column. 
> 
> I've tried all afternoon (actually it's 8:20pm now, so all day) to learn
> how to do this, not succeeding.  Everything is beyond this & going left to 
> right.
> Those you know, please help.  I just want an easy home budget sheet, not a 
> new career.  Thanks so much for any help at all.  My last math class was in 
> 1970.
> -- 
> household appliances should run themselves

date: Thu, 9 Oct 2008 07:25:02 -0700   author:   Jade