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
|