writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 15:
Line 15: − + Line 22:
Line 22: −
Manuals/calci/DPRODUCT (view source)
Revision as of 22:07, 23 November 2013
, 22:07, 23 November 2013→Description
This function returns the product of values from the database that satisfy a given condition.
This function returns the product of values from the database that satisfy a given condition.
*A 'field' argument can be expressed as "Salary" (a column name) or 3(position of the column).
*A 'field' argument can be expressed as "Price" (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' 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.
*'criteria' columns should not overlap the list of data.
DPRODUCT(A3:D7,"Profit",A3:D7) ''returns 40'' as a result.
DPRODUCT(A3:D7,"Profit",A3:D7) ''returns 40'' as a result.
== Examples ==
== Examples ==