Skip to content
TechnoLearnAcademy
TECHNOLEARN
Menu
Home
About us
Trainer
Contact us
Fee
Login
Register
Home
Previous
Next
EXCEL DCOUNT
The DCOUNT
is an Excel function to count cells in a range that meets specified criteria.
Syntax
:
      = DCOUNT(
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
Objective
: Find the count of cells where quantity is greater then 2
   Step 1
:
Type = sign in cell I5.
Type
DCOUNT
Function
 Â
Step 2
:
Select range
A2:F22
Type “,”
   Step 3:
Type
F2
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 is greater than 2.
Â
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS SQL
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
Scroll to Top