DCOUNT Function

The DCOUNT function is used to calculate the count of items from a table/database range.

Formula:


=DCOUNT((DatabaseRange,FieldName,CriteriaRange)
Whereas DatabaseRange is the entire table/database (including the title), FieldName is the field for which the count has to be taken and CriteriaRange is the name of the FieldName.

Video Tutorial:


Let us find the count of items from the table/database, using DCOUNT function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question