**excel experts help me!**

H

helpmeplz

hey can you guys help me with something on excel?

I have 1 column of data that says doctor or custodian. Then I have a
2nd column that says male (value=1) or female (value=2). How do I find
out how many male doctorss there are? Which function do I use?

This is giving me a headache. Thanks for your help!
 
R

Rowan Drummond

with your data in A2:B15 try:

=SUMPRODUCT(--($A$2:$A$15="Doctor"),--($B$2:$B$15=1))

or enter Doctor in Cell D1 and 1 in D2 and try
=SUMPRODUCT(--($A$2:$A$15=D1),--($B$2:$B$15=D2))

Hope this helps
Rowan
 
J

Jef Gorbach

Presuming this is a rare/one-shot question, why not sort the male doctors
together then manually insert a line between the custodians and doctors and
another before the first female doctor then auto-sum column2 ??
 
Top