survey says

  • Thread starter Thread starter Rick Merrill
  • Start date Start date
R

Rick Merrill

I want to tally up the results of a survey by putting a check mark or a "1" for
every yes response in a Cell. But how do I take the sum of the bits? (ie. as if the end result were a binary number, "1111111111111" ?)

I suppose I could use a push button!
 
If the tally cell was A1, I guess you could just check the length of the
data.

=LEN(A1)

If A1 contained 1111111111

LEN(A1) = 10

but I think you might be limited if you use 1s as it will be treated as a
number and 20 1s would show as 1.11111111111111E+24

Using "y"s might work better

Regards

Trevor
 
Trevor said:
If the tally cell was A1, I guess you could just check the length of the
data.

=LEN(A1)

If A1 contained 1111111111

LEN(A1) = 10

but I think you might be limited if you use 1s as it will be treated as a
number and 20 1s would show as 1.11111111111111E+24

Using "y"s might work better

Regards

Trevor
Click to expand...

Thank you, Trevor, that's perfect!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign numeric value to a form check box? 4
Tally Strokes / Command Button / Macro 1
tallying survey results 2
Button to add 1 to the value of a cell 10
Need help on this....thanks 4
How do you tabulate results of a survey in Word? 1
Analyzing Results of a Survey Using Option Buttons 2
Average Formula 1

Back
Top