NB_ELEMENTS ()

In a column of type formula, the NB_ELEMENTS () function is used to display the number of elements contained in selected columns.

Formula

NB_ELEMENTS (Column1, Column2)

See the tips.

Example 1

NB_ELEMENTS (Documents received)

I counted the number of items in the Received Document column to know the number.

Example 2

NB_ELEMENTS (Received Documents, Subscription)

I counted the number of items in the Received Documents column + the number of items in the Subscriptions column to know the number of items in my client's file.

Example 3

In the same way, I can count the number of elements linked to another table.

NB_ELEMENTS (Invoice)

I counted the number of invoice statements from my Invoice column issued to a given customer.