countif on multiple criteria

[sumesh56]

i have a worksheet of students. they belong to(Names in A2:A30,sex=
column= boys/girls,(Area=D column=rural/urban,Catagory=
column=general/obc/sc/st) catagories. i want to get the number o
students belongs to boy-rural-general(multiple criteria) how can i fram
a countif formula to get the numbers

it should be something like--=countif(A2:A30,G1=boys & Rural & General

 

[Claus Busch]

Hi,

Am Thu, 21 Mar 2013 00:27:44 +0000 schrieb sumesh56:

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?

for excel version xl2007 or later:
=COUNTIFS(C2:C20,"boys",D220,"rural",E2:E20,"general")
for all versions:
=SUMPRODUCT(--(C2:C20="boys"),--(D220="rural"),--(E2:E20="general"))


Regards
Claus Busch