A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to: For […]
Create or change a cell reference Read More »
Introduction There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied. Optional: Download our practice workbook. Watch the video below to learn more about cell
Relative and Absolute Cell References Read More »
By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)—in the same row (2). When
Switch between relative, absolute, and mixed references Read More »
Use CONCATENATE, one of the text functions, to join two or more text strings into one string. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not
CONCATENATE function Read More »
The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met. Syntax COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments: Important: Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: For example: Syntax COUNTIF(range, criteria) Argument name Description range (required) The group of cells you want to
Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells. Syntax COUNTBLANK(range) The COUNTBLANK function syntax has the following arguments: Remark Cells with formulas that return “” (empty text) are also counted. Cells with zero values are not counted. Example Copy the example data in the following table, and paste
COUNTBLANK function Read More »
This article describes the formula syntax and usage of the COUNTA function in Microsoft Excel. Description The COUNTA function counts the number of cells that are not empty in a range. Syntax COUNTA(value1, [value2], …) The COUNTA function syntax has the following arguments: Remarks Example Copy the example data in the following table, and paste it in cell A1
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In
