## How to use the AREAS function

The AREAS function returns the number of cell ranges and single cells in a reference.

Formula in cell B3:

=AREAS(E3:E4)

### Excel Function Syntax

AREAS(*reference*)

### Arguments

reference |
Required. A reference to a cell(s) or a cell range(s). |

### Comments

Use parentheses to include multiple arguments as a single argument.

### Functions in 'Lookup and reference' category

The AREAS function function is one of many functions in the 'Lookup and reference' category.

Returns the address of a specific cell, you need to provide a row and column number.

Returns the number of cell ranges and single cells in a reference.

Gets a value based on a number.

Returns the column number of the top-left cell of a cell reference.

Calculates the number of columns in a cell range.

Returns a filtered list

Returns a formula as a text string.

Searches the top row in a data range for a value and return another value on the same column in a row you specify.

Builds a link in a cell.

Returns a value or reference from a cell range, you specify which value based on a row and column number.

Returns the cell reference based on a text string and shows the content of that cell reference.

Find a value in a cell range and return a corresponding value on the same row.

Returns the relative position of an item in an array that matchesÂ a specified value in a specific order.

Returns a reference to a range that is a given number of rows and columns from a given reference.

Calculates the row number of a cell reference.

Calculate the number of rows in a cell range.

Sorts values from a cell range or array

Sorts a cell range or array based on values in a corresponding range or array.

Downloads stock prices based on a stock quote

Converts a vertical range to a horizontal range, or vice versa.

Returns a unique or unique distinct list

Lets you search the leftmost column for a value and return another value on the same row in a column you specify.

Search one column for a search value, and return a corresponding value in another column from the same row.

Searches for an item in an array or cell range and returns the relative position.

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Paste image link to your comment.

Contact OscarYou can contact me through this contact form