Just a point of clarification:
The reason I need to use DCOUNTA is because the column of Project Numbers is
part of a database, and I need to use Criteria from other columns within the
database.


"Bob" wrote:

I have a column containing hundreds of Project Numbers (e.g., P8763, PA3229,
P1090.1, etc.), and the same Project Number can appear more than once in the
column. I need to count the number of unique Project Numbers within that
column. Is there a way to do that? Any help would be greatly appreciated.
Thanks.