Manuals/calci/DAVERAGE
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 |