Assign numeric value to a form check box?

[joenova]

I'm building a form to track survey responses. I've got five colums, on
for each response. The response for each of these is essentially
boolean; Yes or No (True or False). The top of each column returns th
SUM of that column so I can get a quick glimpse of the survey result
for each response type.

I'd like to use a check box to record the responses. However, it seem
that check boxes don't register as a "1" or a "0", so the the sum a
the top of each column never changes.

I'd like to know if there is a way to assign numeric values to a for
check boxes two states, so that I can use check boxes not only t
record the responses, but also to tally them using SUM.

Thanks

 

[Bob Phillips]

Use a formula of

=SUMPRODUCT(--A2:A20)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[joenova]

Nope, no go.

When I set a check box to checked, the sum does not change.

- Jo

 

[Dave Peterson]

How about:

=countif(a1:a20,true)

I'm building a form to track survey responses. I've got five colums, one
for each response. The response for each of these is essentially a
boolean; Yes or No (True or False). The top of each column returns the
SUM of that column so I can get a quick glimpse of the survey results
for each response type.

I'd like to use a check box to record the responses. However, it seems
that check boxes don't register as a "1" or a "0", so the the sum at
the top of each column never changes.

I'd like to know if there is a way to assign numeric values to a form
check boxes two states, so that I can use check boxes not only to
record the responses, but also to tally them using SUM.

Thanks!

 

[Bob Phillips]

It works fine if you create it correctly, otherwise you must have some other
problem.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)