Sum up cells based on the value yes/no

[rxman911]

First the disclaimer: As a Firefighter, I'm new to being an administrator or working with excel but as a newly appointed scoutmaster for my boys, I'm doing my best. We are preparing for summer camp and I have a spreadsheet that I need to extract some info and was hoping to get it done automatically.

Here's the question: I have three columns, Column A responses are Y or N for yes or no to attending, Column B responses are M or F for male or female, Column C responses are Y or A for youth or adult.

I need to extract the following:
number of male scouts attending
number of female scouts attending
number of male adults attending
number of female adults attending

any help is appreciated

 

[kweaver]

Welcome to Mr. Excel.

Ideally, if you could show a sample of your sheet using XL2BB I'm confident you'll get some feedback.

 

[kweaver]

Maybe this?

Book2
	A	B	C	D	E	F	G	H
1	Name	Attending	Gender	Youth/Adult	# Male Scouts	# Female Scouts	# Male Adults	# Female Adults
2	Person1	Y	M	Y	2	1	1	2
3	Person2	Y	M	Y
4	Person3	Y	F	Y
5	Person4	Y	F	A
6	Person5	N	M	A
7	Person6	Y	F	A
8	Person7	N	M	A
9	Person8	N	F	Y
10	Person9	Y	M	A
11	Person10	N	F	A
Scouts

Cell Formulas
Range	Formula
E2	E2	=COUNTIFS($B$2:$B$11,"Y",$C$2:$C$11,"M",$D$2:$D$11,"Y")
F2	F2	=COUNTIFS($B$2:$B$11,"Y",$C$2:$C$11,"F",$D$2:$D$11,"Y")
G2	G2	=COUNTIFS($B$2:$B$11,"Y",$C$2:$C$11,"M",$D$2:$D$11,"A")
H2	H2	=COUNTIFS($B$2:$B$11,"Y",$C$2:$C$11,"F",$D$2:$D$11,"A")

 

[rxman911]

These worked well, I thank you for the help.

 

[kweaver]

Happy to have helped.