writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 18:
Line 18: + + + + + − + − − Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data. − + − + − + − + − + − + + − + − | class="sshl_f" | <40+ − | class="sshl_f" | >5000 − | class="sshl_f" | >32 − |- class="even" − | class="sshl_f" | − − + − |- class="odd"+ − | class="sshl_f" | '''Name''' − | class="sshl_f" | '''Age''' − | class="sshl_f" | '''Salary''' − | class="sshl_f" | − + − + − + − + + − + − + − + − + + − + − + − + − + + − + − + − + − + + − + − + − + − | class="sshl_f" |+ − |- class="odd" − | class="sshl_f" | Jill − | class="sshl_f" | 45 − | class="ssh1_f" | 8000 − − + − − =DPRODUCT() : − +
Manuals/calci/DPRODUCT (view source)
Revision as of 22:05, 23 November 2013
, 22:05, 23 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.
*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 ==
== Examples ==
Consider the following table with Employee names, Age and Salary columns.
Consider the following table with Stationary Items, Quantity, Price and Percentage Profit.
<div id="2SpaceContent" class="zcontent" align="left">
<div id="4SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE2" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" | '''Name'''
| class="sshl_f" | '''Item'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Quantity'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Price'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Profit'''
|- class="odd"
|- class="odd"
| class="sshl_f" |
| class="sshl_f" | Pen
| class="sshl_f" | >10
| class="sshl_f" | >30
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="ssh1_f" |
|- class="even"
|- class="even"
| class="sshl_f" | John
| class="sshl_f" | '''Item'''
| class="sshl_f" | 34
| class="sshl_f" | '''Quantity'''
| class="sshl_f" | 5500
| class="sshl_f" | '''Price'''
| class="sshl_f" |
| class="sshl_f" | '''Profit'''
|- class="odd"
|- class="odd"
| class="sshl_f" | Bill
| class="sshl_f" | Pen
| class="sshl_f" | 35
| class="sshl_f" | 12
| class="sshl_f" | 6500
| class="sshl_f" | 40
| class="sshl_f" |
| class="sshl_f" | 2
|- class="even"
|- class="even"
| class="sshl_f" | Clark
| class="sshl_f" | Pencil
| class="sshl_f" | 29
| class="sshl_f" | 20
| class="sshl_f" | 7000
| class="sshl_f" | 20
| class="sshl_f" |
| class="sshl_f" | 1
|- class="odd"
|- class="odd"
| class="sshl_f" | Bob
| class="sshl_f" | Books
| class="sshl_f" | 45
| class="sshl_f" | 25
| class="sshl_f" | 9000
| class="sshl_f" | 75
| class="sshl_f" |
| class="ssh1_f" | 5
|- class="even"
|- class="even"
| class="sshl_f" | Susan
| class="sshl_f" | Pen
| class="sshl_f" | 37
| class="sshl_f" | 30
| class="sshl_f" | 4000
| class="sshl_f" | 93.33
| class="sshl_f" | 4
| class="sshl_f" |
|}
|}
=DPRODUCT() :
= DPRODUCT(A3:D7,"Profit",A1:B2) : Calculates the product of percentage profits of Pens in the range A3 to D7, for the cells with Quantity>10. ''Returns 8'' as a result.
=DPRODUCT() :
= DPRODUCT(A3:D7,4,A3:D7) : Calculates the product in the range A3 to D7, of all values in Profit column. ''Returns 40'' as a result.
== See Also ==
== See Also ==