Re: Formulas using multiple { }

=SUMPRODUCT(('DATA ENTRY ***'!$A$2:$A$4={2,4,"A","B"}) *('DATA ENTRY
***'!$B$2:$B$4=100)*('DATA ENTRY ***'!$C$2:$C$4={"C","P","S","T"})*'DATA
ENTRY ***'!$D$2:$D$4)

worked fine for me, but it doesn't use an OR logic. I doubt it is what you
want.

--
Regards,
Tom Ogilvy



"Sean" <Sean@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F6FD23E0-FE66-4EF6-860F-065BA1ADDF76@xxxxxxxxxxxxxxxx
> Please see the following formulas and explanations / questions...
>
> FORMULA ONE
> =SUMPRODUCT(('DATA ENTRY ***'!$A$2:$A$4=3)*('DATA ENTRY
> ***'!$B$2:$B$4=100)*('DATA ENTRY ***'!$C$2:$C$4="")*'DATA ENTRY
> ***'!$D$2:$D$4)
>
> This formula works fine.
>
> FORMULA TWO
> =SUMPRODUCT(('DATA ENTRY ***'!$A$2:$A$4="")*('DATA ENTRY
> ***'!$B$2:$B$4=100)*('DATA ENTRY
***'!$C$2:$C$4={"C","P","S","T"})*'DATA
> ENTRY ***'!$D$2:$D$4)
>
> And so does this one.
>
> Now I change FORMULA ONE first array from =3) too ={2,4,"A","B"}) and it
> works fine. No problem, but I notice that FORMULA ONE did not have a { }
> option in it before. PLEASE NOTE
>
> Now I change FORMULA TWO first array from = 3) too ={2,4,"A","B"}) and
it's
> cell comes back with #N/A, now again FORMULA TWO already has an { }
option
> in it, in its third array. PLEASE NOTE
>
> My question I guess would be is how to get the program to except multiple
> uses of { } Or any other help to get around it would be greatly
appreciated.
>
> The way I see it is { } gives you the option to equel too multiple things,
> is there another way to tell it NE "not to equel too" but show everything
> else.
>
> Any suggestions or help!!!??? Thanks in advance to whom ever has my
> solution!!!


.