CatDaddy
06-21-2011, 02:45 PM
dash.Cells(i, 3).FormulaR1C1 = "=SUMPRODUCT((ALL!A:A=""" & MKPArray(i) & """)*(ALL!C:C= ""Y""))"
yeilds formula in cell:
=SUMPRODUCT((ALL!A: (A)="Criteria")*(ALL!C:C="Y"))
why would the first part show up wrong but the second part no problem...
yeilds formula in cell:
=SUMPRODUCT((ALL!A: (A)="Criteria")*(ALL!C:C="Y"))
why would the first part show up wrong but the second part no problem...