Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
This is my Third Post Please Help !!!!!!
I need the total to show the SUM everytime I update INCOME & EXPENSE
Example: Total: ______ A B 1 Income Expense 2 $50 -$20 3 $100 -$10 P.S.: Everyday someone inputs new DATA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
This is my Third Post Please Help !!!!!!
http://www.cpearson.com/excel/newposte.htm
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Need help with sumif" wrote in message... I need the total to show the SUM everytime I update INCOME & EXPENSE Example: Total: ______ A B 1 Income Expense 2 $50 -$20 3 $100 -$10 P.S.: Everyday someone inputs new DATA |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
This is my Third Post Please Help !!!!!!
=sum(a:b)
Don't put it in column A or B. Need help with sumif wrote: I need the total to show the SUM everytime I update INCOME & EXPENSE Example: Total: ______ A B 1 Income Expense 2 $50 -$20 3 $100 -$10 P.S.: Everyday someone inputs new DATA -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
This is my Third Post Please Help !!!!!!
If you want to show the sum of income and expense for each row then in C2 put:
=A2+B2 and copy down. If you want to show the sum of income and expense for each column, then in A100 put: =sum(A2:A99) and in B100 put =sum(B2:B99) to handle 99 entries -- Gary's Student "Need help with sumif" wrote: I need the total to show the SUM everytime I update INCOME & EXPENSE Example: Total: ______ A B 1 Income Expense 2 $50 -$20 3 $100 -$10 P.S.: Everyday someone inputs new DATA |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
This is my Third Post Please Help !!!!!!
Need help with sumif Wrote: I need the total to show the SUM everytime I update INCOME & EXPENSE Example: Total: ______ A B 1 Income Expense 2 $50 -$20 3 $100 -$10 P.S.: Everyday someone inputs new DATA OK, how about htis? Depending on how far down your revenue and expense are going to go, this formula will assume 220 rows so in the cell you want the total enter this formula =sum(B1:B223)-sum(C2:C223) you can change the range to your needs -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=531191 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
This is my Third Post Please Help !!!!!!
davesexcel Wrote: OK, how about htis? Depending on how far down your revenue and expense are going to go, this formula will assume 220 rows so in the cell you want the total enter this formula =sum(A1:A223)-sum(B2:B223) you can change the range to your needs This formula works if your expenses values are not negative -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=531191 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Should I generally request "post a poll" when I post a new thread? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Re post the exact formulas | Excel Worksheet Functions |