# percentage formula

#### aberphil

##### New Member
i've got a column of 'yes' and 'no's and need a formula to work out the percentage of 'yes's. it also needs to allow for the fact that the column is to be added to frequently as more results come in.?? would greatly appreciate a fix to this headache

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### dr_shivan

##### Active Member
assuming your yes and no are in 2 column regardless of sequence
column B and C

=COUNTIF(B:C, "yes")/COUNTA(B:C)%

paste the above into a cell in any column other than B or C. Modify if your columns are more

Replies
14
Views
411
Replies
2
Views
434
Replies
8
Views
253
Replies
2
Views
247
Replies
1
Views
143

1,181,249
Messages
5,928,916
Members
436,634
Latest member
JimHHH

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back