COUNTIF function

This topic describes the formula syntax and usage of the COUNTIF function in the Data Quality Execute Formula transform.

Description

Counts the number of fields within a range that meet the given criteria.

Syntax

COUNTIF(range,criteria)

The COUNTIF function has the following arguments:

  • range Required. Range of columns in which to count fields.
  • criteria Required. The criteria to apply the count.

Example

Table 1. Data
Column1 Column2 Column3 Column4 Column5 Column6
salamanders frogs birds lizards salamanders bears
Table 2. Sample
Formula Description Result
COUNTIF("[Column1]:]Column6],"salamanders") Counts salamanders in fields. 2