| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to view Total as it gets updated
I would like to update income & Expense everyday and total to change
everytime I enter new income & 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Want to view Total as it gets updated
how about:
=SUM(B:B)-ABS(SUM(C:C)) -- Hope this helps, MarkN "Need help with sumif" wrote: I would like to update income & Expense everyday and total to change everytime I enter new income & 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cumulative Total with a twist | Excel Discussion (Misc queries) | |||
| Comparing numbers and subtracting from a total | New Users to Excel | |||
| Subtotals in a Pivot Table | Excel Discussion (Misc queries) | |||
| Total remaining formula | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
