Suming ifcount / isnumber totals

[mkyb14]

If by using this method is there a way to have it total the sum of the column of 1's produced without having to drag out each column and do the formula over and over.

=COUNTIF(A2:A206,"Male")
or
=IF(ISNUMBER(SEARCH("Male",A3:A101)),1,"")
This out puts a 1 next to each male in the column if true.

What about doing that, but having it just return a number of the total male count.
So, if Male + 18yrs = 12
if Male + 19yrs = 2

etc. which or what is the appropriate way to do this?

Thank you.

 

[c_m_s_jr]

Without seeing a sample of your data try:

{=SUM(IF(ISNUMBER(FIND("Male",A1:A10)),1,""))}

confirm with ctrl+shift+enter to get the {}, do NOT enter the {} yourself.

 

[Aladin Akyurek]

If by using this method is there a way to have it total the sum of the column of 1's produced without having to drag out each column and do the formula over and over.

=COUNTIF(A2:A206,"Male")
or
=IF(ISNUMBER(SEARCH("Male",A3:A101)),1,"")
This out puts a 1 next to each male in the column if true.

What about doing that, but having it just return a number of the total male count.
So, if Male + 18yrs = 12
if Male + 19yrs = 2

etc. which or what is the appropriate way to do this?

Thank you.

A3:A101 does apparently house the gender, that is, either Male or Female. What/which range does house the age values like "18yrs", "19yrs", etc.?

 

[mkyb14]

Ok I got that, thanks... can you tell me what the ctrl+shift+enter is doing, and why so I can learn?

 

[mkyb14]

to give you an idea of the data ... its a survey where the rows are mixed between male and female... I'm looking for a way to sort the males from the females and total their ages. So calling all Males, 18yrs old = output total number of 18yr olds. 2 or 54 ... how ever many took the survey.

http://www.wonderliver.com/downloads/master2.xlsx
sheet titled 18-29