Skip to main content
Workday User Guide
Last Updated: 2023-06-23
WD.COUNTIF

WD.COUNTIF

Description

Returns the number of specified values that meet the condition (criterion). You can use the * wildcard to match string values. This function is the same as COUNTIF but WD.COUNTIF creates an index (b-tree) for the specified range or array, providing better performance for repeated use on the same range/array. Null and error values are ignored.

Syntax

WD.COUNTIF(
range
,
criteria
)
  • range
    : The range or array of values to be counted if the condition is met.
  • criteria
    : The condition to use to evaluate the values.