Hi,

I have a table which consists of questions whose answers are only Yes/No/NA. I would like to see total number of Yes,No and NA for all questions. I can sum them for only one row, but I want to do that for all table. After that, I want to take percentage of them without NA i.e.

(total yes) / (total yes+ total no) and

(total no) / (total yes+ total no)

Then, I would like to have their graph as total yes-total no-total NA and percentage yes and no.

How can I do this?

Thanks

I have a table which consists of questions whose answers are only Yes/No/NA. I would like to see total number of Yes,No and NA for all questions. I can sum them for only one row, but I want to do that for all table. After that, I want to take percentage of them without NA i.e.

(total yes) / (total yes+ total no) and

(total no) / (total yes+ total no)

Then, I would like to have their graph as total yes-total no-total NA and percentage yes and no.

How can I do this?

Thanks