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.
Â
