Count(), CountA(), CountRows() and CountX() Functions

Both Count() and CountA() functions counts non-blank values but works with different data types.

Count() = works with Numbers, Dates and String data types only

CountA() = works with All data types

CountRows() counts all the values including blanks.

CountX() allows you to write expressions in the function

Each function has its own use case so depending on whether you want to count non-blank rows only or all the rows or what’s the data type of the column against which you are going to count and whether you have an expression to be evaluated helps you decide which function is a good fit for your scenario.

If there are NO rows to count, each of these functions returns BLANK value, otherwise, they return either the count or zero depending on rows satisfying the condition.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s