View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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