Originally Posted by 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",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