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