Thread: Sumproduct
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Sumproduct

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