> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/array/array-count",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference material for ARRAY_COUNT function

# ARRAY_COUNT

Counts the number of elements in an array for which `function(array[i])` evaluates to TRUE, if a function is provided.
If `<function>` is not provided, counts the number of elements in the array that evaluate to TRUE, equivalent to using `x -> x`.
To count the elements in an array without any conditions, use the [ARRAY\_LENGTH](/reference-sql/functions-reference/array/array-length) function instead.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ARRAY_COUNT(<function>, <array>)
```

## Parameters

| Parameter    | Description                                                                                                                                                                      | Supported input types                                               |
| :----------- | :------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :------------------------------------------------------------------ |
| `<function>` | Optional. A [Lambda function](/guides/sql-dialect/arrays#lambda-function-general-syntax) used to check elements in the array. If `<function>` is not provided, `x -> x` is used. | Any Lambda function returning `BOOLEAN`                             |
| `<array>`    | An array of elements                                                                                                                                                             | Any `ARRAY` type if `<function>` is provided, else `ARRAY(BOOLEAN)` |

## Return Type

`INTEGER`

## Examples

The example below searches through the array for any elements that are greater than 3. Only one number that matches this criteria is found, so the function returns `1`

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	ARRAY_COUNT(x -> x > 3, [ 1, 2, 3, 9, NULL ]) AS levels;
```

**Returns**: `1`

In this example below, there is no `<function>` provided in the `ARRAY_COUNT` function. This means the function will count all of the elements in the array that evaluate to TRUE. Below, this is the case for all values except `FALSE` and `null`:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	ARRAY_COUNT([TRUE, FALSE, 2::BOOLEAN, 3 is not null, null is null, null]) AS levels;
```

**Returns**: `4`