+ Reply to Thread
Results 1 to 2 of 2

Want to view Total as it gets updated

  1. #1
    Need help with sumif
    Guest

    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. #2
    MarkN
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1