Formulas & functions
How a function works, with worked examples you can paste.
- Sort Excel Oldest to Newest: Dates, Data, and FixesTo sort dates in Excel from oldest to newest, select a cell in the date column, then choose Data > Sort Oldest…
- Sort Excel Rows by Column Value: A Practical GuideTo sort rows in Excel by a column value, click a cell in the data, then choose Data > Sort A to…
- Sort Excel by Month: Dates, Names, and Custom Lists EasilyTo sort Excel by month, select the full data range and choose Data > Sort. Sort real date values by the date…
- Sort Excel Data by Date: Steps and TroubleshootingTo sort Excel data by date, select the entire table or the date column within it, then choose Data > Sort Oldest…
- Sort Excel by Column for the Entire WorksheetTo sort a column without separating its rows, click a cell in your data, choose Data > Sort, select the column and…
- Sort Excel by Highlighted Rows: Step-by-StepYes. In Excel for Microsoft 365 on Windows, select the entire table, open Data > Sort, set Sort On to Cell Color,…
- Sort Excel by Color: Cells, Font Colors, and IconsTo sort Excel rows by color in Microsoft 365 for Windows, select your data, choose Data > Sort, select the column under…
- How to Sort Excel Alphabetically by First ColumnTo sort an Excel list alphabetically by its first column, click a cell in that column and choose Data > Sort A…
- Excel Sort Multiple Columns: Rules, Steps, and TipsTo sort Excel data by multiple columns, select a cell in the data, choose Data > Sort, then use Add Level to…
- How to Sort Alphabetically in Excel Without Mixing RowsTo sort alphabetically in Excel for Microsoft 365 on Windows, select a cell in the column, then choose Data > Sort A…
- Sort an Entire Excel Spreadsheet by One ColumnTo sort an entire Excel spreadsheet by one column, click a cell in your data, choose Data > Sort, select the column…
- Is INDIRECT Volatile in Excel? Performance ExplainedYes. INDIRECT is a volatile Excel function, so it recalculates whenever Excel recalculates, even when the cells named in its text reference…
- Excel Sort Entire Row by One Column Without Splitting DataYes. To sort entire rows by one column in Excel for Microsoft 365 on Windows, select the full data range, go to…
- Excel INDIRECT: Link to Another Tab with a FormulaTo refer to a cell on another worksheet using a sheet name stored in A1, enter =INDIRECT("'"&A1&"'!B2"). If A1 contains January, the…
- Excel INDIRECT Named Range: How It Works and When to Use ItIn Excel, INDIRECT turns text into a cell or range reference, so you can use it to refer to a named range…
- Excel INDIRECT Function: Reference Another SheetYes. In Excel, INDIRECT can turn a text string containing a worksheet reference into a usable reference. For example, if Sheet2 contains…
- Excel INDIRECT Sheet Name: Build Dynamic Sheet ReferencesTo use a cell’s text as a worksheet name in Excel, combine it with the cell or range you want and pass…
- Excel INDIRECT: Reference Cells on Another SheetYes. In Excel for Microsoft 365, INDIRECT can turn a text reference into a reference to a cell on another sheet: with…
- Excel INDIRECT: Reference Another Workbook or FileYes. Excel’s INDIRECT function can refer to a cell in another workbook, but the source workbook must be open; if it is…
- OFFSET in Excel: Syntax, Examples, and UsesIn Excel, OFFSET returns a reference to a cell or range located a specified number of rows and columns from a starting…
- Excel OFFSET Height: How the Argument Works in FormulasIn Excel, OFFSET’s height argument sets how many rows the returned reference includes; it does not control how far the reference moves.…
- Excel Vertical Lookup: VLOOKUP, XLOOKUP, and TipsAn Excel vertical lookup searches down the first column of a table for a value, then returns related information from another column…
- Average Filtered Column in Excel: Formula and TipsTo average only the visible rows in a filtered Excel column, use =SUBTOTAL(1,B2:B100), replacing B2:B100 with your data range. SUBTOTAL recalculates when…
- Average Except 0 in Excel: Formula and ExamplesTo average values in Excel while excluding zeros, use =AVERAGEIF(A2:A10,"<>0"), replacing A2:A10 with your data range. The formula averages the numeric values…
- SUMPRODUCT Excel: Calculate a Weighted AverageIn Excel, calculate a weighted average with =SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5), assuming A2:A5 contains the values and B2:B5 contains their weights. SUMPRODUCT multiplies each value…
- SUMPRODUCT in Excel: Multiple Criteria ExplainedYes. In Excel, SUMPRODUCT can sum values that meet multiple criteria by multiplying TRUE/FALSE tests together; for example, with regions in A2:A6,…
- SUMPRODUCT in Excel: How Its Array Calculations WorkIn Excel, SUMPRODUCT multiplies corresponding values in one or more arrays and adds the resulting products. It is especially useful for totals…
- SUMPRODUCT in Excel: Conditional CalculationsYes. In Excel, SUMPRODUCT can add values that meet one or more conditions by turning each condition into an array of TRUE…
- SUMPRODUCT in Excel: What It Contains and How It WorksExcel’s SUMPRODUCT contains one required array argument and optional additional arrays; it multiplies corresponding entries across the arrays, then adds those products.…
- Excel SUMPRODUCT Sample Data: How to Use It in FormulasExcel’s SUMPRODUCT multiplies corresponding values in ranges and adds the results, so it can calculate totals such as units sold times unit…