Excel - Formula problem

[ajw150]

Hi,

I am new to this forum, but in desperate need of some Excel help.

I have created a long series of questions and the answers are in th
form of "check boxes". If the user clicks the YES checkbox to
questions I want to be able to "add" them up, and come up with
result, i.e ANSWER. If the user clicked 3 YES and 1 NO, I want
different answer to appear.

I am not too sure if I am on the right track, as so far I was wonderin
if I need to give the TRUE a number and so on?

Hope this message is not too confusing. Hope you know what I mean. I
there are any other ways of doing this, please feel free to let m
know.

Thanks

Andre

 

[Rollin_Again]

I am still a little confused. Is your format similar to th
following----> You have a question in a cell A1, cell B1 would b
checked with the letter X or something similar for a True answer o
cell C1 would be checked for False? This pattern would then b
repeated for the following rows? Please try to explain what you ar
trying to accomplish in detail and I'll be glad to help you. Try t
give some real examples of what you want to happen.


Rolli

 

[Ron]

Use the COUNTIF function to count the true answers in a range. In another cell you can use the same function for False answers. I am assuming you are using "checkboxes" from the form controls. Hope this help