Name
DMIN
Synopsis
Use
DMIN to find the smallest number in a
column of a database table that matches the conditions specified by
the Criteria
argument.
To Calculate
=DMIN(Database
,Field
,Criteria
)
All three arguments are required for this function.
Example
Figure 17-2 illustrates how to use DMIN to find the least amount of sales dollars generated for a month by salesperson 145.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.