Total
 

Total $1,655(I want this cell to be updated as I type in income & expense)

A B C D
1 Date Item Income Expense
2 4/5/2006 Paycheck $1,500
3 4/5/2006 Bonus $200
4 4/6/2006 Music CD -$20
5 4/6/2006 Meal -$25

Total
 

SUM(C:C)+SUM(D:D)

"Need help with sumif" wrote:

Total $1,655(I want this cell to be updated as I type in income & expense)

A B C D
1 Date Item Income Expense
2 4/5/2006 Paycheck $1,500
3 4/5/2006 Bonus $200
4 4/6/2006 Music CD -$20
5 4/6/2006 Meal -$25