1. Messages
  2. Excel Formula

moderated Re: Excel Formula

Russell Solowoniuk
 

Hi Steve,

Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula, 
CountIf(B2:B100,”Yes”).
This will give you the number of cells with “Yes” in them.
Then, in B102, or whoever you wish, type the formula,
=CountA(B2:B100)
Note the letter “A” after “Count” in the above formula.
This will give you the total number of cells in column B that have data.
Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula,
=B101/B102
You are dividing the number of “Yes” by the total number of cells with data.
You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK.

Hope this helps.

Russell

On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@...> wrote:

Hi All, 
 
Using Excel 2016, Windows 10 and the current version of JAWS.  I have an Excel sheet in column A I have the task a person must perform.  In Column B I will answer yes or no if they can perform the task.  Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions.  I would greatly appreciate your assistance!
 
Steve
 
Join main@jfw.groups.io to automatically receive all group messages.