Specific usage of AREAS function in Excel

php editor Zimo believes that Excel is one of the most commonly used software in the office. As a powerful spreadsheet software, it can help us better manage data and information. In addition to basic data processing and calculation functions, Excel's function library is also a powerful feature. This article focuses on the specific usage and precautions of the AREAS function in Excel, hoping to be helpful to the majority of Excel users.

1. The Areas function is defined as: returning the number of areas contained in the reference.

2. The usage format of Areas function is: =AREAS(reference).

3. Among them, the parameter Reference is a reference to a certain cell or cell range, and can also refer to multiple ranges.

4. In the case shown in the figure, we enter the formula in the blank cell: =AREAS(A2:B4).

5. Confirm the formula and press the Enter key to return the result [1].

6. If we add a few more areas, enter the formula: =AREAS((A1:A3, A4:A6, B4:B7, A16:A18)), that is, return Result [4].

The above is the detailed content of Specific usage of AREAS function in Excel. For more information, please follow other related articles on the PHP Chinese website!