moderated Re: Excel Formula
Hi Steve,toggle quoted messageShow quoted text
Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula,
This will give you the number of cells with “Yes” in them.
Then, in B102, or whoever you wish, type the formula,
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,
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.