Using it twice AGAIN!!!
 

I got a reply, but no answer came with it. I'll submit it again. Here is
the original question????? THANKS!!!!!!!!!!!!!!!!!

-------------------------------------------------------------------------------------------------

Ok, I figured out the whole {} meaning and how it works, here is my formula
that I need changed...

=SUMPRODUCT(('DATA ENTRY SHEET'!$A$2:$A$4=3)*('DATA ENTRY
SHEET'!$B$2:$B$4=200)*('DATA ENTRY SHEET'!$C$2:$C$4={"D","E"})*'DATA ENTRY
SHEET'!$F$2:$F$4)

I want to replace the first array of =3) to
={"",0,2,9,10,56,5600,88,203,204,205})

Now it lets me do it how ever I get a #REF on it. I've tried putting it all
in "" taking out the ""'s removeing the 0's everything!!! Any help would be
great. Thanks

Sean