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 …
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 …
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, …
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 …
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 — …
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 …
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 …
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, …
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 …