Advanced Excel Formulas – DCOUNT Function Description With Example

[ResponsiveRect]
Advance Excel Formulas

Count the number of products of a particular Brand which have a Life Hours rating.

Criteria Range Is E23:E24

DCOUNT

DATABASE FORMULA – DCOUNT Function

What Does It Do ?
This function examines a list of information and counts the values in a specified column. It can only count values, the text items and blank cells are ignored.

Syntax
=DCOUNT(DatabaseRange,FieldName,CriteriaRange)

Description For DCOUNT Function

  • The DatabaseRange is the entire list of information you need to examine, including the field names at the top of the columns.
  • The FieldName is the name, or cell, of the values to Count, such as “Value Of Stock” or I3.
  • The CriteriaRange is made up of two types of information.
    The first set of information is the name, or names, of the Fields(s) to be used as the basis for selecting the records, such as the category Brand or Wattage.
    The second set of information is the actual record, or records, which are to be selected, such as Horizon as a brand name, or 100 as the wattage.

Formatting
No special formatting is needed.

GenronTech Header-Cartoon

[ResponsiveRect]


Examples 1

The count of a particular product, with a specific number of boxes in stock.

DCOUNT1_03Criteria Range Is E50:F51

The number of products is : DCOUNT1_10  =DCOUNT(B3:I19,H3,E50:F51)

This is the same calculation but using the name “Boxes In Stock” instead of the cell address.

DCOUNT1_10 =DCOUNT(B3:I19,”Boxes In Stock”,E50:F51)


Examples 2

The count of the number of  Bulb products equal to a particular Wattage.

Example1Criteria Range Is E61:F62

The count is : DCOUNT1_14 =DCOUNT(B3:I19,”Boxes In Stock”,E61:F62)


Examples 3

The count of Bulb products between two Wattage values.

Criteria rangeCriteria Range Is E68:G69

The count is DCOUNT1_17 =DCOUNT(B3:I19,”Boxes In Stock”,E68:G69)

 

GenronTech Header-Cartoon

Advanced Excel Formulas Index

  1. Jump To Advance Excel Formulas Main Menu
  2. Jump To Database Function
  3. Jump To Date and Time Function
  4. Jump To Financial Function
  5. Jump To Informational Function
  6. Jump to Logical Function
  7. Jump To Math Function
  8. Jump to Statistical Function
  9. Jump To Engineering Function
  10. Jump To Text Function

Add a Comment

Your email address will not be published. Required fields are marked *