Sum Functions
SUM(range): Adds all the numbers in a range of cells.
Example: =SUM(A1:A10) adds all the numbers in cells A1 through A10.
SUMIF(range, criteria, [sum_range]): Adds the cells specified by a given condition.
Example: =SUMIF(A1:A10, “>5”, B1:B10) sums all the numbers in B1 through B10 where the corresponding values in A1 through A10 are greater than 5.
SUMPRODUCT(array1, [array2], …): Multiplies corresponding components in the given arrays, and returns the sum of those products.
Example: =SUMPRODUCT(A1:A3, B1:B3) will multiply corresponding cells in both arrays and sum them up.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com