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)

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",D2:D20,"rural",E2:E20,"gen eral")
for all versions:
=SUMPRODUCT(--(C2:C20="boys"),--(D2:D20="rural"),--(E2:E20="general"))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

thanks a lot for the suggestion. it works nicely in 2007 version which i am using at resent.(btw how can i show that this thread has been solved? in your reply the colon is hided by an icon and it is not visible.)thanks once again and have a nice day.