Formula help

[Bert]

Column A may or may not have an "X" in it to represent
whether or not someone attended training (x means they
did).
Column B lists whether they are an doctor, secretary,
assistant, etc....

I want a formula at the bottom that will count the number
of people that are doctors and that attended training. I
was able to get the count of doctors, but I am having
trouble including the additional field that If they are a
doctor AND they have an X in column A count that. Thanks

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(A1:A100="X"),--(B1:B100="doctor"))

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A1000="X")*(B1:B1000="Doctor"))

or
=SUMPRODUCT(--(A1:A1000="X"),--(B1:B1000="Doctor"))

 

[Guest]

Try using a pivot table.

 

[Bert]

Can you tell me what the dashes represent in the formula?

 

[Frank Kabel]

Hi
they coerce the boolean values to numbers:
TRUE = 1
FALSE = 0

 

[peter_clouse]

The easiest way I know to do this is to add 2 columns.
Use the AND function in the first (I believe you have to
put "doctor" in quote marks), and then use the IF function
in the second , IF(true, 1, ""), and there will only
appear "1" in the cells corresponding to both conditions.
I do not know of a one-step method.

Good luck.