Formulas using multiple { }
 

Please see the following formulas and explanations / questions...

FORMULA ONE
=SUMPRODUCT(('DATA ENTRY SHEET'!$A$2:$A$4=3)*('DATA ENTRY
SHEET'!$B$2:$B$4=100)*('DATA ENTRY SHEET'!$C$2:$C$4="")*'DATA ENTRY
SHEET'!$D$2:$D$4)

This formula works fine.

FORMULA TWO
=SUMPRODUCT(('DATA ENTRY SHEET'!$A$2:$A$4="")*('DATA ENTRY
SHEET'!$B$2:$B$4=100)*('DATA ENTRY SHEET'!$C$2:$C$4={"C","P","S","T"})*'DATA
ENTRY SHEET'!$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!!!

Formulas using multiple { }
 

=SUMPRODUCT(('DATA ENTRY SHEET'!$A$2:$A$4={2,4,"A","B"}) *('DATA ENTRY
SHEET'!$B$2:$B$4=100)*('DATA ENTRY SHEET'!$C$2:$C$4={"C","P","S","T"})*'DATA
ENTRY SHEET'!$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" wrote in message
...
Please see the following formulas and explanations / questions...

FORMULA ONE
=SUMPRODUCT(('DATA ENTRY SHEET'!$A$2:$A$4=3)*('DATA ENTRY
SHEET'!$B$2:$B$4=100)*('DATA ENTRY SHEET'!$C$2:$C$4="")*'DATA ENTRY
SHEET'!$D$2:$D$4)

This formula works fine.

FORMULA TWO
=SUMPRODUCT(('DATA ENTRY SHEET'!$A$2:$A$4="")*('DATA ENTRY
SHEET'!$B$2:$B$4=100)*('DATA ENTRY
SHEET'!$C$2:$C$4={"C","P","S","T"})*'DATA
ENTRY SHEET'!$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!!!