Thread: Sumproduct
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Sumproduct

One way:

=SUMPRODUCT(--(examinations="ribs"),--(LEFT(type,1)="m"),
--(radiographer="koos"))

In article ,
Batim wrote:

=SUMPRODUCT(--(examinations="ribs"),--(type="mine"),--(radiographer="koos")).
In this formula how can I change type= to look for everything stating
with m and not the word mine.

Regads