using "or" twice
"Sean" wrote:
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
|