Name
DPRODUCT
Synopsis
Use
DPRODUCT to find the product of the
values in a column of a database table that matches the conditions
specified by the Criteria argument. The
product is determined by multiplying the matching values from the
specified column.
To Calculate
=DPRODUCT(Database,Field,Criteria)
All three arguments are required for this function.
Example
Figure 17-2 illustrates how to use DPRODUCT to find the product of the number of demos given 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.
