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
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
=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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks