DEVI

Revision as of 22:57, 7 November 2013 by Abin (talk | contribs)

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]