Vts = {{2, 1, 3, f}, {7, 1, 4, m}, {1, 4, 8, f}, {3, 4, 7, f}};
v = Select[Vts, MemberQ[#, f] &]
{{2, 1, 3, f}, {1, 4, 8, f}, {3, 4, 7, f}}
v[[All, 2]]
{1, 4, 4}

Replace f by Female

Query makes this sort of task easy.

Vts = {{"1 VTS", 2., 2., 5., 2., 5., "Female"},
   {"1 VTS", 2., 2., 5., 2., 5., "Male"},
   {"1 VTS", 2., 2., 5., 2., 5., "Female"}};
Query[Select[#[[7]] == "Female" &], 2]@Vts

A slight modification will give the total.

Query[Select[#[[7]] == "Female" &] /* Total, 2]@Vts

Hello Okkes,

I was trying the code but i did not work, i think that i am doing something wrong (i am learning). I would like to add the notebook and the excel file, probably i'll understand better with the code in the notebook

Thank you

Attachments:

Hello David,

Thanks for the advice. But what i am trying to do is select only one column or any column that is associated to two variables, in this case what i want to do is, for example, select the information in the second column that is associated to a specific gender (male or female) and to the variable 1 VTS (first column). For now i know how to select information that is associated to the variables in the first column, to do that i use Part[Select[data, #[[1]] == "1 VTS" &], All, 3], but i do not know how to do it with the gender.

It will be of great help if you can gave me an example directly in mathematica note book.

Thank you

Attachments:

Just what I was doing! The attached file uses a select similar to Marco's. You will find it in the last section.

Attachments:

Hello David,

I appreciate your help, now i'm going to replicate the code with my data.

Thank you very much

Hello Marco,

Thank you very much for your help and your explanations, i going to try to aplly the code to my data

greetings