Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
Find a "date" in a column of dates in Excel 2000 | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Find a empty cell in next column | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions |