Re: Excel Formula
toggle quoted messageShow quoted text
I do not know what cell in column B your answers will start and end in. But here is a formula that you can use.
Now, you will have to put in the cells that are covered in column b for b1 and b20 that I put in the formula.
The formula basically counts each cell that has a yes in it for your cell range in column b, and divides it by the total cells that contain answers in your range in column b.
One more thing that you will have to do is to format that cell as a percentage so it will show as a percentage and not a decimal.
Hope this helps.
On Jun 25, 2019, at 7:16 PM, Steve & Shannon Cook <cookcafe@...> wrote: