Jim Thomlinson Wrote:
=SUMPRODUCT(--(examinations="ribs"),--(left(type,
1)="m"),--(radiographer="koos")).

This won't eliminate the occurences of "mine" though would it

--
MDubbelboe
-----------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...fo&userid=3633
View this thread: http://www.excelforum.com/showthread.php?threadid=56215