Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I keep a tally in Excel by going back to the same cell and entering
slash marks without deleting the previous slash marks. This is for a test
and I need to keep a total of how many answered a specific question. Can
someone please help me?

Thank you.
 
duoble click onto the cell (or single click and press F2) to add more slashes.
you could have a function next to it to keep count.
I.e if the slashes are in cell E5 in F5 enter =LEN(E5)
 
Thank you for answering, I guess I was just wondering if I could add
additional numbers to the cell without typing the F2 edit key as I have
numerous questions and I need to go back and tally these cells several times.
 
How can I keep a tally in Excel by going back to the same cell and
entering slash marks without deleting the previous slash marks. This
is for a test and I need to keep a total of how many answered a
specific question.
Click to expand...

This isn't the method you asked for, but it might help.

First the preparation:
- Find an out-of-the-way cell and enter the number 1 there.
- Use "Edit >> Copy" to copy the 1 to the clipboard.
- Select another out-of-the-way cell and use:
Edit >> Paste special >> Operation "Add"

Now for each time you want to increment a tally:
- Select the cell
- Hit the F4 key

So to tally a whole bunch of totals, go:
Select F4 Select F4 Select F4 Select F4 ...

(If you do anything in between, you have to do the preparation again.)
 
Why not just type in the new number?

If you're looking for some kind of "picture", you could use this formula in an
adjacent cell:

=rept("|",a1)

But for something neater, try this:

=REPT(REPT(CHAR(134),4)&" ",INT(A1/5))&REPT("|",MOD(A1,5))
 
Back
Top