Array: An array, an array formula, or a reference to range of cells to which you want the number of rows. How to use the ROW function in Microsoft Excel Launch Microsoft Excel. Type into the cell ...

Remember that a cell reference is basically a cell address, like how you get to the cell (e.g., A2). When you use A2 in a formula, it's a reference relative to the row and column.

Cell References in Excel Formulas When you create a formula in an Excel cell, you'll frequently include a reference to another cell in the spreadsheet.

When you are using Microsoft Excel, it's common to have a formula in one cell reference another cell in order to use that cell's data in a computation. Generally, a cell is referred to using a row ...

Excel’s INDEX function allows users to reference values in a range of data (or array of data) by their column and row number position within that range. As a simple example, the formula =INDEX (A1:F10 ...

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.