How do I count cells with different criteria in excel?
Thanks Teethless Mama!
Your suggestion also works. I'm not sure why but hey why complain!
Thanks,
Richie17
"Teethless mama" wrote:
=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?
|