Returns the k-th smallest value in a data set.Ĭalculates standard deviation based on a sample.Ĭalculates standard deviation of an entire population.Ĭalculates standard deviation based on a sample includes text and logicals.Ĭalculates standard deviation of an entire population includes text and logicals. Returns the rank of a number in a list of numbers: its size relative to other values in the list. Provided for compatibility with earlier versions of Excel. Returns the quartile of a data set, based on percentile values from 0.1, inclusive. Returns the quartile of a data set, based on percentile values from 0.1, exclusive. Returns the quartile of a data set, based on percentile values from 0.1. Returns the rank of a value in a data set as a percentage (0.1, inclusive) of the data set. Returns the rank of a value in a data set as a percentage (0.1, exclusive) of the data set. Returns the rank of a value in a data set as a percentage (0.1) of the data set. Returns the k-th percentile of values in a range, where k is in the range 0.1, inclusive. Returns the k-th percentile of values in a range, where k is in the range 0.1, exclusive. Returns the k-th percentile of values in a range, where k is in the range 0.1. Returns the median, or the number in the middle of the set of given numbers.įinds smallest value in a set of values includes text and logicals. For example, the fifth largest number.įinds largest value in a set of values includes text and logicals. Returns the k-th largest value in a data set. Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals. You can use the following functions in a 3-D reference:Ĭalculates average (arithmetic mean) of numbers.Ĭalculates average (arithmetic mean) of numbers includes text and logicals. Select the cell or range of cells that you want to reference.Ĭomplete the formula, and then press Enter. Hold down the Shift key then click the tab for the last worksheet that you want to reference. Type a = (equal sign), followed by the name of the function (see the table below), and then an opening parenthesis.Ĭlick the tab for the first worksheet that you want to reference. If you move Sheet6 in front of Sheet2, the formula will adjust to point to Sheet2:Sheet5.ĭelete an endpoint - If you delete Sheet2 or Sheet6, Excel removes the values on that worksheet from the calculation.Ĭlick the cell in which you'll enter the function. If you move Sheet2 so that it's after Sheet6 in the workbook, the formula will adjust to point to Sheet3:Sheet6. For example, you may have a reference to Sheet2:Sheet6. If you reverse the end points, the 3-D reference changes the endpoint worksheet. Move an endpoint - If you move Sheet2 or Sheet6 to another location in the same workbook, Excel adjusts the calculation to include the new worksheets between them unless you reverse the order of the endpoints in the workbook. Move - If you move worksheets from between Sheet2 and Sheet6 to a location outside of the referenced worksheet range, Excel removes their values from the calculation. Insert or copy - If you insert or copy worksheets between Sheet2 and Sheet6 (the endpoints in this example), Excel includes all values in cells A2 through A5 in the constituent worksheets in the calculations.ĭelete - If you delete worksheets between Sheet2 and Sheet6, Excel removes their values from the calculation. Each of these examples use the formula =SUM(Sheet2:Sheet6!A2:A5) to add cells A2 through A5 on worksheets 2 through 6: The examples below explain what happens when you insert, copy, delete, or move worksheets that are included in a 3-D reference.
0 kommentar(er)
