I would like to update income amp; Expense everyday and total to change
everytime I enter new income amp; Expense
Total: _$5000_
A B $ C
Date Income Expense
1 4/3/2006 $3000 -$500
2 4/4/2006 $2000 -$300
3 4/5/2006 $1000 -$200
how about:
=SUM(B:B)-ABS(SUM(C:C))
--
Hope this helps,
MarkNquot;Need help with sumifquot; wrote:
gt; I would like to update income amp; Expense everyday and total to change
gt; everytime I enter new income amp; Expense
gt;
gt; Total: _$5000_
gt;
gt; A B $ C
gt; Date Income Expense
gt; 1 4/3/2006 $3000 -$500
gt; 2 4/4/2006 $2000 -$300
gt; 3 4/5/2006 $1000 -$200
- Oct 18 Sat 2008 20:46
Want to view Total as it gets updated
close
全站熱搜
留言列表
發表留言
留言列表

