+ Reply to Thread
Results 1 to 4 of 4

Running counter

  1. #1
    Registered User
    Join Date
    07-13-2009
    Location
    Elsewhere, Nowhere
    MS-Off Ver
    Excel 2007
    Posts
    2

    Running counter

    I was trying to set up a system where if I put in a name and the number there were, That I could keep a running total of how many I have. For instance:
    I put in:
    Name: Number:
    Thing 1
    Other Thing 2
    Thing 3

    and in another tab it shows:

    Name: Number:
    Thing 4
    Other Thing 3

    and it would continue to add them up as I add more to the list.
    How would I program something like that?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,953

    Re: Running counter

    Look up SUBTOTALS/COUNT in Help.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-13-2009
    Location
    Elsewhere, Nowhere
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Running counter

    My actual list keeps getting added to, and my main problem was making it so that any new entries were automatically added to the right totals.

  4. #4
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Running counter

    I would opt for creating a dynamic named range for the entire data set and use this named range as the source for a Pivot Table. Use the Pivot Table to create the totals.

    Because the PT source is a dynamic named range you would only need to right-click the Pivot Table and choose refresh to update it and even this part can be easily automated with simple VBA code.

+ 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