close

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()