answersLogoWhite

0

"I have a spreadsheet of results from a survey I have been preforming. In Column I there are results where 1 is yes and 0 is no. I need to be able to calculate the percentage of Yes answers in a separate tab, how do i do this?"

The first thing is to count the total amount of values, using the COUNT function. You then need to find the amount of times 1 comes up, which you can do by just using the SUM function. Then divide the result of the SUM by the result of the COUNT and format the result as a percentage. To specify the Sheet from another sheet, you put the sheet name followed by an exclamation mark and then the cell references.

Let's say your values were in the cells from I2 to I25 on Sheet1, then your final formula with the functions could be as follows:

=SUM(Sheet1!I2:I25)/COUNT(Sheet1!I2:I25)

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What are the outputs of Excel?

The results of formulas that you type in are outputs in Excel. If you do filters, the results you get are outputs. Charts are an output. If you print anything from Excel, that is an output.


How do you calculate the equilibrium level of consumption?

you first have to culculate equilibrium level of income.


Can excel cells contain data information formulas and results?

Yes


How to culculate personal income to disposable income?

Personal Income = Disposable Income + Personal Savings


How do you culculate one percent of a million?

1% = 0.01 and so 0.01 times 1,000,000 = 10,000


What is a way of recording results in columns?

use a spreadsheet like excel, or use a pencil


In Excel a worksheet that displays the formulas used to create the results is called what?

Formula wooksheet


How do you culculate the distance around a circle?

Circumference of any circle = 2*pi*radius or diameter*pi


How do you culculate number of bytes in a characteristic?

The answer depends on the maxmum value or the longest [text] string that the characteristic can take.


What Excel feature you see the results of a cell style before applying it?

The Live Preview feature.


What was the Excel multiplication bug?

It caused some multiplications to return erroneous results. The multiplications included 77.1*850, 5.1*12850, and 10.2*6425. They should return results of either 65,535 or 65,536 but in Excel 2007 they returned a result of 100,000 instead.


How do you culculate the gross spread ratio of a bank?

Gross Spread for Banks = (Net Markup Income/Gross Income)