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?
Hi,
Formula:
Please Login or Register to view this content.
where x is the number of questions. Formatted as a %
Gives the % of 'Agrees'. Change the 1 to a 2 for the % of Disagrees.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks