---
title: "Use the COUNTOF Function to Count Nonblank Values in a Block"
slug: "countof-function"
description: "Learn to use the COUNTOF function to count non-BLANK values across Dimensions in a Block in Pigment."
updated: 2025-05-28T10:24:27Z
published: 2025-08-22T12:00:18Z
---

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

# COUNTOF function

## ​​​Description

Counts the number of non-`BLANK` values of a Block.

## Syntax

`COUNTOF(Block)`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Block* (required) | Any | Any |  |

## Returns

| Type | Dimensions |
| --- | --- |
| Integer | No Dimension |

## Examples

Employee is a Dimension List:

| Formula | Result | Description |
| --- | --- | --- |
| `COUNTOF(Employee)` | 4 | The Employee List contains 4 items. For a List, all items are counted. |
| `COUNTOF(Employee.Name)` | 3 | The Property Name contains 3 non-`BLANK` values. |

## See also

Excel: [COUNTA](https://support.microsoft.com/en-us/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509)

Related articles: [COUNTALLOF,](/v1/docs/countallof-function) [COUNTOF,](/v1/docs/countof-function) [COUNTBLANKOF](/v1/docs/countblankof-function)

> [!TIP]
> **More of a hands-on learner?**
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>