+ Reply to Thread
Results 1 to 2 of 2

How to tally series of 1's in a single cell?

  1. #1
    Registered User
    Join Date
    11-29-2007
    Posts
    1

    How to tally series of 1's in a single cell?

    Hi
    I would like to use excel as a sort of 'dynamic' tally chart (for my classroom) so that as pupils periodically enter a series of, say, 1's in a cell, the total number of 1's appears in an adjacent cell. Would appreciate help.
    Sprout

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    =LEN(A1) - LEN(SUBSTITUTE(A1,1,""))

    In the future, please provide titles that are descriptive of your problem rather than (or in addition to) being clever.

+ 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