Since mine starts with "m" it will still be there. You could exclude it if
you wnated something like this
=SUMPRODUCT(--(examinations="ribs"),--(left(type,
1)="m"),--(type<"Mine"), --(radiographer="koos"))
--
HTH...
Jim Thomlinson
"MDubbelboer" wrote:
Jim Thomlinson Wrote:
=SUMPRODUCT(--(examinations="ribs"),--(left(type,
1)="m"),--(radiographer="koos")).
This won't eliminate the occurences of "mine" though would it?
--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=562155