| Line 29: |
Line 29: |
| | Consider the following table with Employee names, Age and Salary columns. | | Consider the following table with Employee names, Age and Salary columns. |
| | Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data. | | Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data. |
| − | <!--
| + | UNIQe5afd1fc935bfb36-item-3--QINU |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| − | | |
| − | DCOUNT
| |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">Let's see an example</font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">C1 C2 C3 </font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R1 Name Age Salary </font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R2 <30 </font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R3 >40 >5000</font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R4 Name Age Salary</font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R5 John 34 5500 </font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R6 Bill 35 6500 </font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R7 Clark 29 7000 </font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R8 Bob 45 9000</font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R9 Susan 37 4000</font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R10 Jill 45 8000 </font>]
| |
| − | | |
| − | <font color="#0000ff"><br /></font>
| |
| − | | |
| − | [javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">I.e =DCOUNT(C1R4:C3R10,”Salary”,C1R1:C2R3) is 3</font>]
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | --> | |
| − | | |
| | <div id="2SpaceContent" class="zcontent" align="left"> | | <div id="2SpaceContent" class="zcontent" align="left"> |
| | | | |
| Line 159: |
Line 96: |
| | | | |
| | =DCOUNT(A4:C10,3,A1:C2) : Counts the number of cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age<40 and Salary>5000. ''Displays 3'' as a result. | | =DCOUNT(A4:C10,3,A1:C2) : Counts the number of cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age<40 and Salary>5000. ''Displays 3'' as a result. |
| | + | |
| | + | == See Also == |
| | + | {{#ev:youtube|D_1-SavHX-M|280|center|DCOUNT}} |
| | | | |
| | == See Also == | | == See Also == |