I am trying to take a SumProduct on a cell that works correctly, and translate it to a user form with a 3 textboxs(instead of the three cells). No matter what i try i get a "Unable to get the SumProduct property of the WorksheetFunction class". When i type in the code, the intellisense pops up and i actually pick it from there. I cannot figure out what step i am missing. I have tried other functions as well (Vlookup, SumIf) and get the same error. I've used Application.WorkSheetFunct
ion and WorkSheetFunction with the same result.
Code below works in a cell on the sheet (i never could get the syntax right to make it work with a named range)
=SUMPRODUCT(SUMIF('Prize List'!$A$6:$E$69|Z13:AB13|'Prize List'!$B$6:$B$69))