I created an excel sheet to record pre and post survey test answers.

The survey has questions saying agree/disagree, so in the excel sheet I put 1 for agree and 2 for disagree.

I want to calculate the percentage of "agrees" or "disagrees" per column. So simply a percentage of "2"s in a column, OR a percentage of "1"s in a column. How can I do this simply?