Excel FILTER Function: How to Use It, with Examples
Turkish: FİLTRE

Filters the rows that meet a condition and returns them as a new list.

FILTER syntax

=FILTER(array, include, [if_empty])

In Turkish Excel: =FİLTRE(dizi; ekle; [boşsa])

ArgumentDescription
arrayThe range to filter.
includeThe condition (e.g. B2:B6="Ankara").
[if_empty]Value to return if nothing matches.

FILTER examples

Sample table:

ABCD
1ProductRegionQuantityPrice
2PenAnkara125
3Notebookİzmir820
4EraserAnkara302
5NotebookAnkara520
6Penİzmir75
=SUM(FILTER(C2:C6,B2:B6="İzmir"))
Result: 15

Filters the İzmir rows and adds up their quantities.

Results were calculated in real Excel.

Tips for FILTER

  • Available in Excel 2021 and Microsoft 365.

Related functions

More formula guides

More tools

About FILTER Function

Filters the rows that meet a condition and returns them as a new list.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use FILTER Function

  1. Type the formulaStart typing =FILTER( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is FILTER in Turkish Excel?

In Turkish Excel, FILTER is called FİLTRE. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have FILTER?

FILTER is available in Excel 2021 and Microsoft 365.