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

Regad

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

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

=SUMPRODUCT(--(examinations="ribs"),--(left(type,
1)="m"),--(radiographer="koos")).
--
HTH...

Jim Thomlinson


"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


--
Batim
------------------------------------------------------------------------
Batim's Profile: http://www.excelforum.com/member.php...o&userid=36413
View this thread: http://www.excelforum.com/showthread...hreadid=562155

Thanks it is working. Where can I get learn all this stuff:)


--
Batim
------------------------------------------------------------------------
Batim's Profile: http://www.excelforum.com/member.php...o&userid=36413
View this thread: http://www.excelforum.com/showthread...hreadid=562155

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

Here is the definitive reference on sumproduct. Bob Phillips is the author
and he hangs around here if there is anything more that you wanted to know...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Batim" wrote:


Thanks it is working. Where can I get learn all this stuff:)


--
Batim
------------------------------------------------------------------------
Batim's Profile: http://www.excelforum.com/member.php...o&userid=36413
View this thread: http://www.excelforum.com/showthread...hreadid=562155

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