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

Maybe...

=sumproduct(--(b2:b50="male"),--(a2:a50="Primary"))

=sumproduct() likes to work with numbers. The -- stuff converts True/False's to
1/0's.

If you have lots of categories, you may want to look into using a pivottable.

davidtips wrote:

:) Hi Andy

I'm not counting the cell with colour, but text, (ex: how many "male"
in B2:B50 ?) , but need to based on which Class at A2:A50, (ex:
primary1, primary2 or more).

Thanks for your helps!
davidiew

--
davidtips
------------------------------------------------------------------------
davidtips's Profile: http://www.excelforum.com/member.php...o&userid=19103
View this thread: http://www.excelforum.com/showthread...hreadid=488178


--

Dave Peterson