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
|