Function returning value with assigned binary value

[tennentslager]

I'm looking for a function that would return a value which has a binary characteristic assigned to it. More specifically, a function that would only return the values with 1 assigned to them (i.e. male employees) into the male employee list but disregard any female (i.e. 0) employees

[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee[/TD]
[TD]Male[/TD]
[TD][/TD]
[TD][/TD]
[TD]Male employees[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]Jane[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD]Martin[/TD]
[/TR]
[TR]
[TD]Martin[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Fred[/TD]
[/TR]
[TR]
[TD]Marta[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD]Jim[/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Jack[/TD]
[/TR]
[TR]
[TD]Francesca[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD]Johnie[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Johnie[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Lara[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

thanks a lot in advance!

 

[AhoyNC]

Is this what you are trying to do?
Formula in E2 is an array formula that must be entered with CTRL-SHIFT-ENTER. Drag formula down as needed.

If you have Excel ver. 2010 or later you can use the formula in G2 which doesn't require CTRL-SHIFT-ENTER. Copy this formula down as needed.

Excel Workbook
	A	B	C	D	E	F	G
1	Employee	Male			Male employees	6	= # of Males
2	John	1			John		John
3	Jane	0			Martin		Martin
4	Martin	1			Fred		Fred
5	Marta	0			Jim		Jim
6	Fred	1			Jack		Jack
7	Francesca	0			Johnie		Johnie
8	Jim	1
9	Jack	1
10	Johnie	1
11	Lara	0
Sheet

 

[tennentslager]

Yeah that works perfectly, cheers

 

[AhoyNC]

You're welcome. Thanks for the feedback.