Learn Excel skills from beginner to advanced with video tutorials, templates, and tips from Microsoft Support.

Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting two blank cells, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...

Automatically number rows Article; Calculate the difference between two dates Article; Define and use names in formulas Article; Combine text from two or more cells into one cell

The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE.. One common use for the AND function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to ...

向量形式. LOOKUP 的向量形式在单行区域或单列区域（称为“向量”）中查找值，然后返回第二个单行区域或单列区域中相同位置的值。. 语法. LOOKUP(lookup_value, lookup_vector, [result_vector]) LOOKUP 函数向量形式语法具有以下参数：. lookup_value 必需。LOOKUP 在第一个向量中搜索的值。

Example. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

This article describes the formula syntax and usage of the HLOOKUP function in Microsoft Excel.. Description. Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.

This video is part of a training course called Advanced IF functions.. Syntax. COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments:

This article describes the formula syntax and usage of the ROUNDUP function in Microsoft Excel.. Description. Rounds a number up, away from 0 (zero). Syntax. ROUNDUP(number, num_digits)