Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions you specify.
The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Indicates which column is used in the function. Field can be given as text with the column label enclosed in quotation marks, such as "Age" or "Yield," or as a number that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
The range of cells that contains the conditions that you specify.
The following illustration shows a database for a small orchard. Each record contains information about one tree.
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.