Thread: Pls Help Me!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
davidtips
 
Posts: n/a
Default Pls Help Me!


:) :) 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