Thread
:
Counting more than one criteria
View Single Post
#
3
Posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
Posts: 11,058
Counting more than one criteria
For 4 Male In:
=SUMPRODUCT(--(B1:B100=4),--(C1:C100="Male"),--(D1:D100="IN"))
--
Gary''s Student - gsnu200770
Reply With Quote
Gary''s Student
View Public Profile
Find all posts by Gary''s Student