Manuals/calci/DPRODUCT

DPRODUCT(database, field, criteria)

• Where 'database' is the range of cells that makes up the list or database

• 'field' shows which column is used in the function and

• 'criteria' is the range of cells that contains the specified condition.

DPRODUCT() multiplies the values in a column of a list or database that match the specified condition.

Description

DPRODUCT(database, field, criteria)

This function returns the product of values from the database that satisfy the given condition.

• A 'field' argument can be expressed as "Salary" (a column name) or 3(position of the column).
• 'criteria' can be any range on the Calci with minimum of one column and at least one row indicating the condition.
• 'criteria' columns should not overlap the list of data.

Examples

Consider the following table with Employee names, Age and Salary columns.

Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.

Name	Age	Salary	Age
	<40	>5000	>32
	>30
Name	Age	Salary
John	34	5500
Bill	35	6500
Clark	29	7000
Bob	45	9000
Susan	37	4000
Jill	45	8000

=DPRODUCT() :

=DPRODUCT() :

=DPRODUCT() :

See Also

• DSUM
• DAVERAGE

References

• List of Aggregate Functions
• DPRODUCT