**excel experts help me!**

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!

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

helpmeplz wrote:
> 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!
>
>

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 ??

"helpmeplz" <[email protected]> wrote
in message news:[email protected]...
>
> 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!
>
>
> --
> helpmeplz
> ------------------------------------------------------------------------
> helpmeplz's Profile:
http://www.excelforum.com/member.php...o&userid=29193
> View this thread: http://www.excelforum.com/showthread...hreadid=489278
>