Thanks Merjet, but what I need is to use DCOUNTA. This is the
specification for the task. I already know about the CountIF as I
have mentioned in my first post.

Again, I need to use DCOUNTA due to the project specification
requirement.