Find Percent something in particular in a column.
 

I want to find the percent of lets say Males in a column of M/F that meet a
criteria in a seperate cell. For example Males that met a standard.

Find Percent something in particular in a column.
 

Let M or F be in A1:A100
Let B1:B100 have data for standard: a X means they met the standard (good
looking?)

The counts the males with X: =SUMPRODUCT(--(A1:A100="M"),--(B1:B100="X")
That is two negative signs in front of opening parentheses. See
http://www.xldynamic.com/source/xld.SUMPRODUCT.html for details

You want %of males? Divide by number of males
=SUMPRODUCT(--(A1:A100="M"),--(B1:B100="X") / COUNTIF(A1:A100,"M")
Format the result as percent.

Of % of all in A?
=SUMPRODUCT(--(A1:A100="M"),--(B1:B100="X") / COUNTA(A1:A100)
{yes I know the count is 100 but you might add some more by inserting
records}


You cannot use A:A in SUMPRODUCT
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Colchabay" wrote in message
...
I want to find the percent of lets say Males in a column of M/F that meet a
criteria in a seperate cell. For example Males that met a standard.