Difference between revisions of "DEVI"
(Created page with "<!-- ---- <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> DCOUNT </div></div> ---- <div id="8SpaceContent" class="zcontent" align=...") |
|||
| Line 1: | Line 1: | ||
| − | + | ||
---- | ---- | ||
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> | ||
| Line 60: | Line 60: | ||
<br /><br /> | <br /><br /> | ||
| − | |||
| − | |||
Revision as of 22:57, 7 November 2013
DCOUNT
[javascript:ToggleDiv('divExpCollAsst_4') Let's see an example]
[javascript:ToggleDiv('divExpCollAsst_4') C1 C2 C3 ]
[javascript:ToggleDiv('divExpCollAsst_4') R1 Name Age Salary ]
[javascript:ToggleDiv('divExpCollAsst_4') R2 <30 ]
[javascript:ToggleDiv('divExpCollAsst_4') R3 >40 >5000]
[javascript:ToggleDiv('divExpCollAsst_4') R4 Name Age Salary]
[javascript:ToggleDiv('divExpCollAsst_4') R5 John 34 5500 ]
[javascript:ToggleDiv('divExpCollAsst_4') R6 Bill 35 6500 ]
[javascript:ToggleDiv('divExpCollAsst_4') R7 Clark 29 7000 ]
[javascript:ToggleDiv('divExpCollAsst_4') R8 Bob 45 9000]
[javascript:ToggleDiv('divExpCollAsst_4') R9 Susan 37 4000]
[javascript:ToggleDiv('divExpCollAsst_4') R10 Jill 45 8000 ]
[javascript:ToggleDiv('divExpCollAsst_4') I.e =DCOUNT(C1R4:C3R10,”Salary”,C1R1:C2R3) is 3]