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