DPRODUCT

Returns the product of values selected from a database table-like array or range using a SQL-like query.

Sample Usage

Syntax

DPRODUCT(database, field, criteria)

• database - The array or range containing the data to consider, structured in such a way that the first row contains the labels for each column's values.

• field - Indicates which column in database contains the values to be extracted and operated on.

  • field may either be a text label corresponding to a column header in the first row of database or a numeric index indicating which column to consider, where the first column has the value 1.

• criteria - An array or range containing zero or more criteria to filter the database values by before operating.

See Also

PRODUCT: Returns the result of multiplying a series of numbers together.

DVARP: Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.

DVAR: Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.

DSUM: Returns the sum of values selected from a database table-like array or range using a SQL-like query.

DSTDEVP: Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.

DSTDEV: Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.

DMIN: Returns the minimum value selected from a database table-like array or range using a SQL-like query.

DMAX: Returns the maximum value selected from a database table-like array or range using a SQL-like query.

DGET: Returns a single value from a database table-like array or range using a SQL-like query.

DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.

DAVERAGE: Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.

In order to use the DPRODUCT formula, start with your edited Excellentable:

	A	B	C	D
1	Name	Date	Test	Score
2	Ramesh	01-Jan-2015	Test2	3
3	Ramesh	01-Jan-2015	Test3	4
4	Ramesh	01-Jan-2015	Test2	3
5	Ramesh	05-Jan-2015	Test3	4
6	Ramesh	05-Jan-2015	Test1	3
7	Ramesh	05-Jan-2015	Test2	3
8	Robert	02-Jan-2015	Test3	4
9	Robert	02-Jan-2015	Test1	3
10	Robert	02-Jan-2015	Test2	3
11	Robert	05-Jan-2015	Test3	4
12	Robert	05-Jan-2015	Test1	3
13	Robert	05-Jan-2015	Test2	3

	E	F	G
1		Name	Date
2		Ramesh	05-Jan-2015
3	DPRODUCT	36
4
5
6
7
8
9
10
11
12
13