Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =SUMPRODUCT(C2:C19,((D2:D19="text1")*12+(D2:D19="text2")*4+(D2:D19="text3")*2))
- Function xxx(x, y)
- xxx = Application.WorksheetFunction.SumProduct(x, ((y = "text1") * 12 + y = "text2" * 4 + y = "text3" * 2))
- End Function
Add Comment
Please, Sign In to add comment