RowCount()

Returns the number of rows in a rowset, array, or object.

This function became available in Marketing Cloud Next during the Summer ’26 release (API version 67.0).

1RowCount(rowset)

The RowCount() function has one parameter:

• rowset (string): Required. The rowset or array to find the number of rows for.

To use the function, pass it a rowset.

1%%=RowCount(LookupRows('PostalCode','City','Indianapolis'))=%%

This example returns the number of rows in the PostalCode data extension where the City column contains the value “Indianapolis.”