Returns the number of rows in a rowset, array, or object.
Availability
<table> <tr> <td>Marketing Cloud Engagement</td> <td>✅ Yes</td> </tr> <tr> <td>Marketing Cloud Next</td> <td>✅ Yes</td> </tr> </table>This function became available in Marketing Cloud Next during the Summer ’26 release (API version 67.0).
Syntax
RowCount(rowset)
The RowCount() function has one parameter:
rowset(string): Required. The rowset or array to find the number of rows for.
Usage
To use the function, pass it a rowset.
%%=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."