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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks