Counting based on conditions

[excel_padwan]

Ok, I solved one part of my problem, now I have another.

I want to count a column containing any value based on the specific values in another column.

For example;

I have age values in one column. The number can be anything, it doesn't matter. However, I have to base that upon sex, which is represented by a 1, 2, or 3 in another column. How can I get the age column to count based on the the value of the sex column, no matter what value is in the age column?

 

[Trevor G]

Does this work for you.

You only need to do a count on the Sex ID surely

Excel Workbook
	A	B	C
1		Sex	Age
2		1	24
3		2	34
4		3	56
5		1	12
6		2	34
7		2	34
8		2	34
9		2	34
10		2	34
11		2	34
12
13	Sex	Total Age	Total
14	1	36	2
15	2	238	7
16	3	56	1
Sheet2

 

[T. Valko]

Ok, I solved one part of my problem, now I have another.

I want to count a column containing any value based on the specific values in another column.

For example;

I have age values in one column. The number can be anything, it doesn't matter. However, I have to base that upon sex, which is represented by a 1, 2, or 3 in another column. How can I get the age column to count based on the the value of the sex column, no matter what value is in the age column?

Can you post some sample data and tell us what result you expect?

 

[excel_padwan]

Say column A is the gender, values 1-3. Column f is the age, whatever number the surveyed group entered.

I want to make column G, H, and I my gender column, sorted male, female, transgendered, respectively. But I don't want them as a count of the data, I want a transference of data into each respective column. Example

A B C D E F G H I
GENDER AGE MALE FEMALE TRANS
1 20
2 24
3 18
1 20

So, as I stated, If column a is a 1, I would like to take the data from column F and transfer the data(20) to the male Column(G), not the count.

Sorry for the crappy table, I don't know how to insert a proper one here.

-J

 

[excel_padwan]

Wow, that table formatting was lost. sorry, I'll try to post a real table

 

[T. Valko]

Wow, that table formatting was lost. sorry, I'll try to post a real table

Is this what you want:

Book1
	A	F	G	H	I
1	GENDER	AGE	MALE	FEMALE	TRANS
2	1	20	20	24	18
3	2	24	20	_	_
4	3	18	_	_	_
5	1	20	_	_	_
Sheet1

 

[excel_padwan]

That is perfect! I apologize for my crappy lost formatted table, but you did great deciphering it.

 

[T. Valko]

That is perfect! I apologize for my crappy lost formatted table, but you did great deciphering it.

The easiest way to do that would be to apply autofilter to the data.

Filter on the Gender column then just copy/paste the data to the appropriate range.