Results 1 to 4 of 4

Thread: Tally Help

  1. #1
    Join Date
    Nov 2004

    Unanswered: Tally Help

    I need help in a formula that will retain a total from a worksheet on totals when the worksheet driving that total is changed. example, if cell E34 equals 20 then the tally (on another worksheet, same workbook) total will equal 20. But when the amount (in E34) is changed to 10 the tally total will equal 10, I want it to equal 30 (retain the amount from previous entry). This is to track running totals. thanks, busman

  2. #2
    Join Date
    Feb 2004
    You will have to log your totals on a worksheet and then use the 'Subtotal' or 'Sum' function to sum the totals. Use the Formula Wizard for help. or click the AutoSum button after selecting the cell where you want the total to appear. Since formuals are based on other values on the same or another worksheet or workbook you will have to phisically type the value or create a process to enter and save values to retain them.



  3. #3
    Join Date
    Oct 2003
    On this thread there are both VBA and formulas possibilities:

    Tallying Cell Counter
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Nov 2004
    Thanks for your help Ill give it a try...busman

Posting Permissions

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