SUMIFS function - Microsoft Support
The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.
INDIRECT function - Microsoft Support
Description. Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself. Syntax. INDIRECT (ref_text, [a1]) The INDIRECT function syntax has the following arguments:
Create a Measure in Power Pivot - Microsoft Support
To Create a Measure by using the Measure Dialog Box in Excel. In the Excel window, click Power Pivot> Calculations> Measures> New Measure. In the Measure dialog box, for Table name, click the down arrow, and then select the table you want the measure to be in.
CONVERT function - Microsoft Support
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. Syntax. CONVERT (number, from_unit, to_unit) Number is the value in from_units to convert. From_unit is the units for number. To_unit is the units for the result.
Define and solve a problem by using Solver - Microsoft Support
Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet.
LINEST function - Microsoft Support
The LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line.
WEEKNUM function - Microsoft Support
Syntax. WEEKNUM (serial_number, [return_type]) The WEEKNUM function syntax has the following arguments: Serial_number Required. A date within the week. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE (2008,5,23) for the 23rd day of May, 2008.
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
ROWS function - Microsoft Support
This article describes the formula syntax and usage of the ROWS function in Microsoft Excel. Description. Returns the number of rows in a reference or array. Syntax. ROWS (array) The ROWS function syntax has the following argument: Array Required. An array, an array formula, or a reference to a range of cells for which you want the number of rows.
Refresh an external data connection in Excel - Microsoft Support
Refresh an external data connection in Excel. To keep imported external data up-to-date, you can refresh it to see recent updates and deletes. Excel provides many options for refreshing data, including when you open the workbook and at timed intervals. Note: To stop a refresh, press Esc.
STDEV.S function - Microsoft Support
STDEV.S function. Estimates standard deviation based on a sample (ignores logical values and text in the sample). The standard deviation is a measure of how widely values are dispersed from the average value (the mean).