I need to determine how many Separations were processed by a particular
salesperson.

A | B
1 MIKE | SEPARATION
2 MIKE | LEAVE
3 SARA | SEPARATION
4 JOE | SEPARATION
5 JAMIE | LEAVE
6 MIKE | LEAVE
7 JOE | LEAVE
8 SARA | SEPARATION

The only way I can think of is the COUNTIF Funtion
*COUNTIF(-range,criteria-)*
=COUNTIF(A1:A8,(A1:A8="MIKE")*(B1:B8="SEPARATION") )
This does not work though. The results return 0 with no errors when
the answer should be 1.

does anyone else know of a way to get what I need? Or is there a
problem with my formula?


--
chrisdedobb
------------------------------------------------------------------------
chrisdedobb's Profile: http://www.excelforum.com/member.php...o&userid=30081
View this thread: http://www.excelforum.com/showthread...hreadid=497615