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
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
http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Need help with sumif"
<[email protected]>
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
OK, how about htis?Originally Posted by Need help with sumif
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
=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
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
This formula works if your expenses values are not negativeOriginally Posted by davesexcel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks