Kingwood Underground
the heart and soul of our Kingwood, Texas family
Login - Create Account - Help
Clean out your garage on Kingwood bookoo! Or find local garage sales on Yard Sale Search.com
KU Live!

Excel - formula question

who's talking here?

jamie 1
Roadrunner 2
austin 1
ItsAllGood 1

     » send to friend     » save in my favorites     » flag dangerous topic flag as a dangerous topic

ItsAllGood --- 16 years ago -

Does anyone know how to use the formulas to make it automatically add and subtract. I use excel as my checkbook ledger and need it to automatically add or subtract each line. please help. 

austin --- 16 years ago -

Sum(cell#:cell#) Will total all cells between them including those. Sum(cell#,cell#) will total just the cells listen separated by commas. I can't remember what the subtraction one is. Depending one your version of office you may have a "formulas" tab at the top. Makes it pretty easy. 

jamie --- 16 years ago -

subtraction is (Cell#)-(Cell#)= 

Roadrunner --- 16 years ago -

Here is a suggestion for you. Once you build the formula in the total column you just copy it down. Formula is +total on row above + deposit - withdrawal. Then just copy it down. Date Description Check # Deposit Withdrawal Balance 1/1/2010 Deposit $10.00 $10.00 1/3/2010 Plumber 1 $5.00 5 1/5/2010 Deposit 100 105 1/10/2010 Randalls 2 63.25 41.75 41.75 41.75 41.75 41.75 41.75 41.75 41.75 41.75 

Roadrunner --- 16 years ago -

Ooops. It wrapped around I can send you an example spreadsheet if you want. 

page 1
Login to add your comments!

see more discussions about...


Online now:
hit counters

Terms of Service - Privacy Policy - Ice Box

Kingwood Underground