# FILTER

## Content

This function allows users to filter a cell range based on the defined criteria. The filter operation can be performed based on a single criterion or multiple criteria.
In order to combine two or more filter conditions, users can use the " \* " operator and the "+" operator. The \* operator will multiply two sets of conditions in order to join the filter criteria with AND logic [when both the filter conditions have to be TRUE]. The + operator will simply join the two sets of conditions with OR logic [when one filter condition can be TRUE and the other can be FALSE].

>type=note
> **Note:** FILTER is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.

## Syntax

`FILTER(array, include, [if_empty])`

## Arguments

FILTER function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *array* | [Required] Specifies the range or array that you want to filter. |
| *include* | [Required] Specifies the filter condition expressed using intersecting sub-range and conditional expressions. |
| *if\_empty* | [Optional] Specifies the optional value that users want to return when the filter result is empty.<br>If a value is not specified for this parameter, then #CALC! error is thrown. |

## Examples

`FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"")`