View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default How do I count cells with different criteria in excel?

=SUM((A1:A100="M")*(B1:B100=6))

ctrl+shift+enter, not just enter


"Richie17" wrote:

I have a column with M or F (Male/Female) and I also have a column that has
their age. How do I count how many 6 year olds there are AND how many of
those are either male or female?