+ Reply to Thread
Results 1 to 3 of 3

How do I count a running total for this?

  1. #1
    Registered User
    Join Date
    07-03-2007
    MS-Off Ver
    2003
    Posts
    77

    How do I count a running total for this?

    In cell A3-A103 I have a column where you would list a date. In cell A104 I need a total of how many dates have been entered.

    For example, Cell A3-A5 contains dates (or any information for that matter) so A104 should indicate 3, since there are 3 dates listed. Once a 4th date is entered in cell A6 the total goes to 4 ... so on and so forth.

  2. #2
    Forum Contributor snasui's Avatar
    Join Date
    07-15-2007
    Location
    Songkhla, Thailand
    MS-Off Ver
    2010, 365
    Posts
    167
    Try this:

    A104

    =Subtotal(3,A3:A103)

  3. #3
    Registered User
    Join Date
    07-03-2007
    MS-Off Ver
    2003
    Posts
    77
    Awesome! Thanks. That worked!

+ 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