help! categorized according to number of males & females

[James Ray]

good day, i just want to categorized age range & education according to number of males & females using excel formula...

sample.jpg

[James Ray]

help me out pls.

[dmg2016]

This will help you the categorized in age.

=COUNTIFS($C$2:$C$7,">="&18,$C$2:$C$7,"<="&35,$B$2:$B$7,"Male")

=COUNTIFS($C$2:$C$7,">="&18,$C$2:$C$7,"<="&35,$B$2:$B$7,"Female")

[humdingaling]

how do you correlate education into those categories??
why is caregiver vocational rather than elementary or high school?

[dmg2016]

These should give you an idea on categorized in education. As humdingaling said, you need to define the criteria a little more.

=COUNTIFS($D$2:$D$7,"Masters*",$B$2:$B$7,K$2)

=COUNTIFS($D$2:$D$7,"BS*",$B$2:$B$7,K$2)

=COUNTIFS($D$2:$D$7,"High*",$B$2:$B$7,K$2)

[James Ray]

thanks a lot for contributing the ideas....