:) :) Thanks!
I have try both ways, and this is the one that suited.
May be you got others way to simplify this fomula!
{=SUM((A1:A10="male")*(B1:B10="primary")}
davidiew
--
davidtips
------------------------------------------------------------------------
davidtips's Profile:
http://www.excelforum.com/member.php...o&userid=19103
View this thread:
http://www.excelforum.com/showthread...hreadid=488178