How to find percentage based on varies values

Hey guys,

I’m looking to my Google sheet has varies columns with values inserted in the rows (62 rows). I want to insert a few rows to represent what percentage of each column is what. For example, Column D is either Y(Yes) or N(No), here I’d like to new row to represent what percentage is Y

 

For example:

Column: Sign up

Rows:

Y

N

N

N

 

Sign up is 25%

 

On a greater scale, I can then use this function for more complex function of Most common time requested. Here I can find based on the same principle, which time is most commonly requested:

Column: Time request

Rows:

10am

2pm

7pm

10am

1pm

10am

 

10am is chosen 50% of the time

By: Arshia

Leave a Reply

Your email address will not be published. Required fields are marked *