EXCEL DCOUNTA
The DCountA is an Excel function to count cells in a range that meets specified criteria.
Syntax:
=DCOUNTA(database,field,criteria)
Arguments or Parameters
database: The range of cells that you want to apply criteria against.
field [optional]: column to count the numeric values that meet the criteria.
criteria: The range of cells that meet the criteria.
Note: DCountA function counts both numeric and text values.
Objective: Find the count of cells where quantity of Product is greater then 2
Step 1:
Type = sign in cell I5.
Type DCOUNTA Function
Step 2:
Select range A2:F22
Type “,”
Step 3:
Type D2
Type “,”
Step 4:
Select range H2:K3
Type “,”
Close the Bracket “)”
Press Enter
Result: The DCount Function has counted 8 cells in cell I5 where Qty of Product is greater than 2.
