Manuals/calci/DAVERAGE

From ZCubes Wiki
Revision as of 21:32, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left">  DAVERAGE(db,fld,cri) <br /> where db is the range of cells that makes up the list or database, fld indicat...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 

DAVERAGE(db,fld,cri)


where db is the range of cells that makes up the list or database,

fld indicates which column is used in the function and

cri is the range of cells that contains the conditions we specify.



 It averages the values in a column of a list or database that match conditions we specify.

DAVERAGE


 

[javascript:ToggleDiv('divExpCollAsst_4') Let's see an example]


[javascript:ToggleDiv('divExpCollAsst_4') C1 C2 C3 C4 ]


[javascript:ToggleDiv('divExpCollAsst_4') R1 Stationary Items Count Price Profit]



[javascript:ToggleDiv('divExpCollAsst_4') R2 Pen 10 40 10]



[javascript:ToggleDiv('divExpCollAsst_4') R3 Pencil 20 30 15]



[javascript:ToggleDiv('divExpCollAsst_4') R4 Books 15 75 20]






[javascript:ToggleDiv('divExpCollAsst_4') I.e. =DAVERAGE(C1R1:C4R6,3,C1R1:C4R4) is 48.333(average price of the items)]


Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1 Stationary Items Count Price Profit
Row2 Pen 10 40 10
Row3 Pencil
20
30 15
Row4 Books 15 75 20
Row5 48.3333