DEVI

---

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]