Mathematical summation (Sigma):
=SUMPRODUCT(ROW(INDIRECT(A1&":"&B1) * 4 - 11)) //equals to sum y = x*4-11 from x = A1 to B1
Choose a in b:
=COMBIN(b, a)
Weighted sum:
=SUMPRODUCT(A1:B10)
Last active
January 11, 2019 11:21
-
-
Save kavhad/ea5250a6181236b840dd4aa40bfe5395 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment