apparently it only works as
=Or(Sumproduct(),Sumproduct())


"Gixxer_J_97" wrote:

hi all

i am trying to combine to sumproduct statements

they are

=Sumproduct((mid(codes,1,2)="DI")*(Types="Sample") )
which works
and
=Sumproduct((mid(codes,1,2)="GB")*(Types="Sample") )
which also works

i tried using
=SUMPRODUCT((OR(MID(Codes,1,2)="DI",MID(Codes,1,2) ="GB"))*(Types="Sample"))
but that returns a 0, not the 1 it should (or i thought it should)

any suggestions?

tia

J