Count If Question?

Hi All:

I have a simple database where basically I am trying to count the number of male winners. In the first column each male or female in column B is labelled as a loser of winner. I tried to use the DCOUNT function to figure out the number of winners that were male and it retuned an error. Here is a screen print:
******** ******************** ************************************************************************> Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows ME (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout D3 =
A B C D E F G H 1 * * * * * * Criteria 2 Outcome Companies * Count* Desired * Funds Companies 3 Winner Male * #VALUE! 5 * Winner Male 4 Loser Female * * * * * * 5 Winner Male * * * * * * 6 Winner Male * * * * * * 7 Winner Female * * * * * * 8 Winner Male * * * * * * 9 Loser Female * * * * * * 10 Loser Male * * * * * * 11 Loser Female * * * * * * 12 Loser Male * * * * * * 13 Winner Female * * * * * * 14 Winner Male * * * * * * 15 Winner Female * * * * * * Sheet1 *
[HtmlMaker 2.20] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Can someone please show me how to modify the formula so it works.

Thanks again for your help,

BA

I need urgent help.

I have data in my excel sheet. I am trying to compare the achievement levels of both boys and girls in years KS2 (primary school),7,8,9.
I entered data into 6 columns; Class, Gender, KS2, year 7, year 8, year 9
however, now when i try to compare my data all the males and females are in different entries on my graph (i.e. male, male,male, female, male, female,female, instead of male, female).
I would ultimatley like to have a scatter graph and bar chart displaying the achievement of both boys and girls. Sooo sorry if that is confusing, please ask if you dont understand. ANY help would be greaaaatly appreciated. thanks in advanced
!!!

Hi
I'm trying what appears to be a complicated bar chart and I'm struggling to get any decent results... Can anyone help?

I have six variables (V1, V2, V3, V4, V5, V6) which represent groups of people. Each of these groups have a male/female split, and so I am representing each variable's male/female split as a percentage.
i.e.
V1: 52.9% Male; 47.1% Female
V2: 52.7% Male; 47.3% Female
V3: 46.2% Male; 53.8% Female etc...

That has produced a very straightforward bar chart where each bar adds-up to 100%. Simples.

However, I also want to add, below each of the variable's (V1, V2, etc...) bars, another bar that splits each male/female group into three further sub-categories (X1, X2, & X3). So, of the 52.9% who are males within V1, X1=61.84%, X2=3.52%, and X3=34.64%; and of the 47.1% who are females witin V1, X1=19.28%, X2=26.65%, and X3=54.06%.
i.e.
V1: 52.9% Male 47.1% Female
V1': 61.84 X1, 3.52% X2, 34.64 X3; 19.28% X1, 26.65% X2, 54.06% X3

The problem is that Excel doesn't seem to like the fact that the bars representing variables V1-6 are split into two groups (male/female) whereas the bars representing the three further sub-categories are split into six (X1,X2,X3,X1,X2,X3) groups.

Have I made any sense there? These things are always quite tricky to explain...

Any help would be very appreciated!

Thanks

Hi,

Please help me with the follwing formula for Taxation puropose.

The two formula to be compliled together for the gender selected

Regards

Shaj

If select male, the formula corresponding to the male should return the result and if its female, it should return the female result. I mean the two formula clubbed together and when the *** column updated(male or female) automatically it should return the result of the gender tax corresponding to that particular employ

Hi, I am trying to do a count on two columns of data -

STATUS GENDER
Active Male
Active Male
Inactive Female
Active Female
etc. etc.

I would like to count all active males or active females. I assume a nested countif would work but i have no clue how to put it together. Any help would be much appreciated!

Regards
Pd

I've already post this in another forum but the reply I get isn't reallt what I needed and no one is replying me anymore. So can anyone help me out here. This is the forum that I've posted on: http://www.excelforum.com/excel-prog...excel-vba.html





Excel VBA - I have this worksheet that have contestant name, gender and racing time. so for eg I have:

Name | Gender | Time | Overall | MaleRank | FemaleRank
Mitch | Male | 15.06
Jess | Female | 16.06
Rach | Female | 17.07
Will | Male | 17.09
and so on...

I want the system to be able to identify the overall(Both male and female) 1st, 2nd and 3rd places under the Overall column, I also want it to be able to identify the Female 1st, 2nd and 3rd places and identify them under FemaleRank column. So same for Male1st, 2nd and 3rd and identify them under MaleRank. All of the ranks need to be calculate with a button click in excel vba forms. So after I clicked the button, the above example will display:

Name | Gender | Time | Overall | MaleRank | FemaleRank
Mitch | Male__ | 15.06 | 1st___| 1st Male _|
Jessy | Female |16.06 | 2nd___|_________| 1st Female
Rache | Female |17.07|_______|_________| 2nd Female
Wille | Male__ | 17.09 | 3rd____| 2nd Male |
and so on...

p.s the time will first be sorted in ascending order and pls ignore the __'s as they are use to make the columns look more understandable. Actually any kind of way to identify the 1st, 2nd and 3rd places is fine but this is the only way I can think of(by making 3 new columns)...


What I want is vba code to loop through the results and identify the ranks for overall, male and female(only top 3 places). Can anyone please help and give a hint cause I really don't know how to do it.

Dear everyone.

I want to create a form such that if we choose the type of bike and the gender of customer, it gonna show up the model number. I tried to use an if function in the name range-define. However, it annouced that the spaces did not enough for my if statement. Can you show me another way to do it? Thanks

Bike Type Gender Model
Hybrid Female 7300 WSD
Hybrid Female 7200 WSD
Hybrid Male 7700
Hybrid Male 7500
Hybrid Male 7300
Hybrid Male 7200
Tandem Unisex T 900
Tandem Unisex Cruiseliner Tandem
Road Female 2100 WSD
Road Female 1600 WSD
Road Female 1000 WSD
Road Female Pilot 1.2 WSD
Road Male 1600
Road Male 1000
Road Female Pilot 5.2 WSD
Triathlon Female Equinox 7 WSD
Road Female Madone 5.0 WSD
Road Female 5000 WSD
Road Male Madone SSL 6.9
Road Male Madone SSL 6.5
Road Male Madone 5.0
Road Male 5000
Road Male 2100
Triathlon Male Equinox 9
Triathlon Male Equinox 7
Triathlon Male Equinox 5
Road Male Pilot 5.0
Road Male Pilot 1.2
Tandem Unisex T 2000
Tandem Unisex T 1000
Triathlon Male Equinox TTX 9.9

Hi all,

I'm using the following COUNTA function for a range of cells.

Quote:

=COUNTA(W92:W580)

In column X92:W58 i have a drop down list to pick a gender, (Male , Female). Can I add to the counta function so that I can count all data entered into W92:W580 and get it filtered by gender.

E,g Say there were 10 data entires within the counta range and 3 were female my table would show: Male: 7 Female: 3 Total:10?

Thanks in advance.

I have to count the number of males and females in certain categories. Lets say column A has ranks like "PV2, PFC, GEN" and in column C you have Male and Female. How can I get a number of Male PFC's or Female PV2?

Column A contains Male or Female. Column B contains a number. I need a formula which will add up the numbers in column b that are male.

A B
Male 10
Female 8
Male 4
Male 8
Male 2
Female 11
Female 3

I am attempting to create a pie chart with percentages hidden within. For instance,

I have counts of how many people like different subjects, and then want to display how many of them were male and female for each. Ideally, this would all make it into one pie chart via VBA.

Math
15 Total
10 Male
5 Female

Science
11 Total
6 Male
5 Female

Language Arts
9 Total
2 Male
7 Female

Etc..

The primary chart would be the totals, and then imbedded in the same graph, the percentage of male vs female would be displayed.

Any assistance would be a tremendous help! I have been coming up with only dead ends.

Thank you in advance,

Stephen

Good Afternoon,

I have a row on my sheet F with values that say either Male or Female. How do i change it to just say F if female or M if Male. Sorry to be such a noob.
Im hoping this is really easy.

hello im creating a charter sheet for a game i play. im trying to get a randomly chosen name to appear based on gender of character. the two formals work by themsself but im having trouble getting the names to correspond to gender.

gender is =INDEX($E$5:$E$6,RANDBETWEEN(1,2)) e5 male
e6 female

for the name =IF(K10=1,INDEX('master names'!$B$2:$B$1355,RANDBETWEEN(1,1354)),INDEX('master names'!$C$2:$C$4383,RANDBETWEEN(1,4382)))

problem is in the logic test, playing around using 0 and 1 it works. if i say k10=male and k10 is male im getting female names.


thank you for help.

Hi wondering if anybody can help?
This is the kind of data table i have, what i need to do is to be able to create a further table showing the different totals of the differing groups be it of ethnic code or gender and then convert these to a percentage of the overall total.


Sun Mon Tue Wed Thu Fri Sat Total 01 02 03 04 05 06 07 david Male Black 0.00 andy Female Black 5.00 5.00 Jim Male White 'British' 0.00 claire Male Black 0.00 matt Male White 'Other' 12.00 12.00 june Female Black 0.00 ann Female Black 0.00 dean Male Asian 7.00 7.00 Sharon Female White 'Other' 0.00 Harry Male Asian 0.00

i.e
Wk Totals % of Overall total White British White Other Black Asian

Here's hoping

Jo

Column G contains race (i.e., black, white, etc.)

Column I contains gender (female or male)

How do I do a sum that will return the count of the number of white females (# of cells that have white in column G with a corresponding female in Column I)?

I am building a weight loss tracker for a contest. I want to rank both the Male team and Female team by total weight lost each week.

What I need to know how to do is in Column U I have a rank formula. What I need it to do is look at columns C and D and determine if the person is male or female and run two different ranks.

For Example if there are 10 people 5 male and 5 female, the rank formula in column U needs to rank just males (column C) 1-5 and then just females (column D) 1-5.

The spreadsheet is attached for reference.

Hello All,
I need some help on find a macro that will search selected data and look for repeats and delete all the repeats the row that accompany's it. Here is an EXample

A B C
1 America 10 Male
2 Japan 10 Male
3 Russia 10 Female
4 America 11 Male
5 Japan 11 Male
6 Russia 11 Female
7 China 11 Female
4 America 12 Male
5 Japan 12 Male
6 Russia 12 Female

Now I would like to highlight everything in Column "B" and run a macro where it will look like this:

A B C
1 America 10 Male
2 America 11 Male
3 America 12 Male

If anybody can help me with this. I would be greatful!

Thank You

I am trying to do a sort on Windows Based and I want ppl who have had no training. I think I have the criteria set right and I have the data selected and I am copying to a new location. When I have the =0 in the second line it displays one Macintosh with zero's and then the rest is Windows based with the second cirteria not being picked up. So I move the formula on the same line as =Windows-based and then I get all it is just copying the database down. What am I doing wrg?

Thanks
Wendy


First Name Last Name Gender Date Hired Department Computer Type Word Excel PP Access Expense =Windows-based =0 =0 =0 =0 First Name Last Name Gender Date Hired Department Computer Type Word Excel PP Access Expense Chang SUN Male 21-Aug-88 Human Resources Macintosh 0 0 0 0 $0 Jane BOXER Female 5-Jul-89 Accounting Windows-based 1 2 1 3 $350 Sue LORD Female 15-Jan-92 Payoll Windows-based 0 2 0 0 $100 Peter BULLARD Male 12-Jan-95 Marketing Windows-based 1 1 3 0 $250 Wayne WHEATON Male 8-Feb-85 Human Resources Macintosh 1 0 2 0 $150 James BAIRD Male 24-Aug-95 Accounting Windows-based 0 3 1 1 $250 Debby KRASNY Female 12-Dec-95 Accounting Windows-based 1 1 1 2 $250 Ralph STEINBERG Male 13-Jan-86 Branch 2 Macintosh 0 3 1 0 $200 Vickie NOLAN Female 25-Mar-88 Branch 1 Windows-based 2 2 0 1 $250 Wayne ROBERTSON Male 4-Apr-92 Human Resources Macintosh 1 2 0 0 $150 Chantele AUTERMAN Female 6-Oct-92 Branch 3 Windows-based 3 1 0 1 $250 Russ SEMARK Male 7-Aug-84 Marketing Windows-based 2 2 3 1 $400 Robert BAUER Male 9-Nov-84 Purchasing Windows-based 0 0 0 0 $0 William EVICH Male 2-Dec-85 Accounting Windows-based 0 3 0 2 $250 Susan RHODES Female 23-Mar-87 Branch 1 Windows-based 1 1 0 0 $100 Chris HART Female 11-Apr-88 Marketing Windows-based 1 0 3 1 $250 Kay DOBBS Female 25-May-90 Payroll Windows-based 0 3 0 1 $200 Tim HILL Male 9-Sep-92 Branch 2 Macintosh 0 3 2 2 $350 Mike O'SULLIVAN Male 20-May-93 Branch 3 Windows-based 0 3 0 0 $150 Beverly ROBERTS Female 12-Sep-93 Branch 3 Windows-based 1 2 1 2 $300 Pat ROWLAND Female 4-Nov-95 Branch 1 Windows-based 1 2 0 0 $150 Archie BAYLIS Male 1-Jun-97 Branch 3 Windows-based 1 2 0 0 $150 First Name Last Name Gender Date Hired Department Computer Type Word Excel PP Access Expense Chang SUN Male 21-Aug-88 Human Resources Macintosh 0 0 0 0 $0 Jane BOXER Female 5-Jul-89 Accounting Windows-based 1 2 1 3 $350

Hi this is probably a frustratingly simple one, but I have tried different variations and my formula just doesn’t work. Any help would greatly greatly be appreciated!
Here goes:

I am converting raw scores to z scores using Norm tables.
There a
- 2 criteria Male or Female (='Client Info'!B6)
- 2 Tables to lookup ‘Female Norms '!A6:N95 and ‘Male Norms '!A6:N94
What I want my vlookup to do is

1:Check cell 'Client Info'!B6 to determine whether the client is male or female, ie If CELL= Male then VLookup (Table that has the male norms) or if CELL=Female then VLookup (table that has the female norms)
2: VLookup the raw score according to the right table (male or female norms) and send back a converted score.

What I have started doing is
=VLOOKUP(F11,’Female Norms’!A6:N95,2,TRUE)
This works but will only allow me to obtain details for one criteria (either male or female)


Please help

Hi,

I have been working on this all day long and I cannot figure it out
I have a sheet with this cell format

Country Age structure(%)
Afghanistan 0-14 years: 44.5% (male 7,664,670/female 7,300,446)
Afghanistan 15-64 years: 53% (male 9,147,846/female 8,679,800
Afghanistan 65 years and over: 2.4% (male 394,572/female 422,603)
Albania 0-14 years: 23.1% (male 440,528/female 400,816)
Albania 15-64 years: 67.1% (male 1,251,001/female 1,190,841)
Albania 65 years and over: 9.8% (male 165,557/female 190,710)

The sheet repeats itself with a number of countries.
I am trying to seperate the first part 0-14 years, 15-64 years and 65 years and over
That would be a new field

A new field for the %
A new field for the male (number)
A new field for the female (number)

Is there a way??