Since only three of the four cells in the range contain data the formula calculates the percentage of yes responses out of three. Add the numbers. Input your desired data eg from cells A1 to A10.
Add the numbers.
Open a new spreadsheet in Excel. It is best to convert the percentages to decimals first. Created with AutoSum the total neither in Cell B5 nor in Cell C5 is correct. The data on 4 examinations showed scores of 75 percent correct 87 percent correct 69 percent correct and 93 percent correct.