Changes

Manuals/calci/DPRODUCT (view source)

215 bytes removed , 21:02, 24 November 2013

no edit summary

Line 18: Line 18:

*'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.

−

*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.~~

== Examples ==

writer

2,661

edits