Hi Guys.
I'm having a hard time figuring out how to use the SumProduct worksheet function in VBA. The below worksheet formula works:
=SUMPRODUCT((accProv=D2)*(accFYE=E2)*(accAcc))
- or -
=SUMPRODUCT(--(accProv=D2),--(accFYE=E2),(accAcc))
I tried the below variations in VBA, and I keep getting run-time error 13. Any ideas?
The dynamic named ranges accProv, accFYE, and accAcc are on sheet Track Changes, and cells D2 and E2 are on sheet Production.Please Login or Register to view this content.
TIA
Jason
Bookmarks