Bots, writer
193,448
edits
Changes
Jump to navigation
Jump to search
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..."
<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 indicates which column is used in the function and
cri is the range of cells that contains the conditions we specify.
<br />
</div>
----
<div id="1SpaceContent" class="zcontent" align="left"> It averages the values in a column of a list or database that match conditions we specify.</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
DAVERAGE
</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">
<u>[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">Let's see an example</font>]</u>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">C1 C2 C3 C4 </font></u>]
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R1 Stationary Items Count Price Profit</font></u>]
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R2 Pen 10 40 10</font></u>]
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R3 Pencil 20 30 15</font></u>]
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R4 Books 15 75 20</font></u>]
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">I.e. =DAVERAGE(C1R1:C4R6,3,C1R1:C4R4) is 48.333(average price of the items)</font></u>]
</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="4SpaceContent" class="zcontent" align="left">
{| id="TABLE2" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| class=" " | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f " | Stationary Items
| class="sshl_f" | Count
| class="sshl_f " | Price
| class="sshl_f" | Profit
|- class="even"
| class=" " | Row2
| class="sshl_f" | Pen
| class="sshl_f " | 10
| class="sshl_f" | 40
| class="sshl_f" | 10
|- class="odd"
| Row3
| class="sshl_f" | Pencil
| class="sshl_f " |
<div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>20
| class="sshl_f" | 30
| class="sshl_f " | 15
|- class="even"
| Row4
| class="sshl_f" | Books
| class="sshl_f" | 15
| class="sshl_f " | 75
| class=" " | 20
|- class="odd"
| class=" " | Row5
| class="sshl_f " |
| class="sshl_f" | 48.3333
| class=" " |
| class=" " |
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----
DAVERAGE(db,fld,cri)
<br />
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.
<br />
</div>
----
<div id="1SpaceContent" class="zcontent" align="left"> It averages the values in a column of a list or database that match conditions we specify.</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
DAVERAGE
</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">
<u>[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">Let's see an example</font>]</u>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">C1 C2 C3 C4 </font></u>]
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R1 Stationary Items Count Price Profit</font></u>]
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R2 Pen 10 40 10</font></u>]
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R3 Pencil 20 30 15</font></u>]
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R4 Books 15 75 20</font></u>]
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
<font color="#0000ff"><br /></font>
[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">I.e. =DAVERAGE(C1R1:C4R6,3,C1R1:C4R4) is 48.333(average price of the items)</font></u>]
</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="4SpaceContent" class="zcontent" align="left">
{| id="TABLE2" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| class=" " | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f " | Stationary Items
| class="sshl_f" | Count
| class="sshl_f " | Price
| class="sshl_f" | Profit
|- class="even"
| class=" " | Row2
| class="sshl_f" | Pen
| class="sshl_f " | 10
| class="sshl_f" | 40
| class="sshl_f" | 10
|- class="odd"
| Row3
| class="sshl_f" | Pencil
| class="sshl_f " |
<div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>20
| class="sshl_f" | 30
| class="sshl_f " | 15
|- class="even"
| Row4
| class="sshl_f" | Books
| class="sshl_f" | 15
| class="sshl_f " | 75
| class=" " | 20
|- class="odd"
| class=" " | Row5
| class="sshl_f " |
| class="sshl_f" | 48.3333
| class=" " |
| class=" " |
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----