Sumproduct

[Batim]

=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

[JE McGimpsey]

One way:

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

In article <[email protected]>,
Batim <[email protected]> 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

[Jim Thomlinson]

=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
>
>

[Batim]

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

[MDubbelboer]

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

This won't eliminate the occurences of "mine" though would it?

[Jim Thomlinson]

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
>
>

[Jim Thomlinson]

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
>
>

[Jim Thomlinson]

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
>
>