Just out curiousity, what are the double minus signs for in the formula?

"PCLIVE" wrote:

One way:

=SUMPRODUCT(--(A1:A5="Finance"),--(B1:B5="EX"))

HTH,
Paul

"Paige" wrote in message
...
Hi, I need to count how many people meet criteria in two different
columns.
See below:

Prod Mktg NX
Finance EX
Ops-Cons Svc NX
Prod Mktg EX
Finance NX

How many people in Finance are also EX?
thanks for the help!!!
--
Paige