writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 18:
Line 18: − *To calculate the product of all values of certain column, the database range should be used as a criteria argument. − For Example considering below table, − − DPRODUCT(A3:D7,"Profit",A3:D7) ''returns 40'' as a result.
Manuals/calci/DPRODUCT (view source)
Revision as of 21:02, 24 November 2013
, 21:02, 24 November 2013no edit summary
*'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.
== Examples ==
== Examples ==