software

I need the total to show the SUM everytime I update INCOME amp; EXPENSE
Example:
Total: ______

A B
1 Income Expense
2 $50 -$20
3 $100 -$10

P.S.: Everyday someone inputs new DATA

www.cpearson.com/excel/newposte.htm

--
Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftware
quot;Need help with sumifquot;
gt;
wrote in message...

I need the total to show the SUM everytime I update INCOME amp; EXPENSE
Example:
Total: ______

A B
1 Income Expense
2 $50 -$20
3 $100 -$10

P.S.: Everyday someone inputs new DATA

=sum(a:b)

Don't put it in column A or B.

Need help with sumif wrote:
gt;
gt; I need the total to show the SUM everytime I update INCOME amp; EXPENSE
gt; Example:
gt; Total: ______
gt;
gt; A B
gt; 1 Income Expense
gt; 2 $50 -$20
gt; 3 $100 -$10
gt;
gt; P.S.: Everyday someone inputs new DATA

--

Dave Peterson

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 Studentquot;Need help with sumifquot; wrote:

gt; I need the total to show the SUM everytime I update INCOME amp; EXPENSE
gt; Example:
gt; Total: ______
gt;
gt; A B
gt; 1 Income Expense
gt; 2 $50 -$20
gt; 3 $100 -$10
gt;
gt; P.S.: Everyday someone inputs new DATA


Need help with sumif Wrote:
gt; I need the total to show the SUM everytime I update INCOME amp; EXPENSE
gt; Example:
gt; Total: ______
gt;
gt; A B
gt; 1 Income Expense
gt; 2 $50 -$20
gt; 3 $100 -$10
gt;
gt; 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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=531191
davesexcel Wrote:
gt; OK, how about htis?
gt;
gt; Depending on how far down your revenue and expense are going to go,
gt; this formula will assume 220 rows so in the cell you want the total
gt; enter this formula
gt;
gt; =sum(A1:A223)-sum(B2:B223)
gt;
gt; you can change the range to your needs

This formula works if your expenses values are not negative--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=531191