| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
countif on multiple criteria
i have a worksheet of students. they belong to(Names in A2:A30,sex=C column= boys/girls,(Area=D column=rural/urban,Catagory=E column=general/obc/sc/st) catagories. i want to get the number of students belongs to boy-rural-general(multiple criteria) how can i frame a countif formula to get the numbers?
it should be something like--=countif(A2:A30,G1=boys & Rural & General) Last edited by sumesh56 : March 21st 13 at 12:30 AM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF COUNTIF - Need Help with multiple criteria | Excel Programming | |||
| COUNTIF with multiple criteria | Excel Worksheet Functions | |||
| Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
| Countif w/ Multiple Criteria | Excel Worksheet Functions | |||
| multiple criteria in a countif | Excel Programming | |||
Threaded Mode
