You may book a private reading here. Welcome to Channeling.Net, your resource of channeled material, includes channeled texts by Emmanuel and archangels Michael and Zadkiel; also offering channeled readings, esoteric message boards and reciprocal links. Established 1998, and so far visited by 1359103 souls.
Writing a Sum Formula. 1  1. Decide what column of numbers or words you would like to add up. 2  2. Select the cell where you'd like the answer to populate. 3  3. Type the equals sign then SUM.  4. Type out the first cell reference, then a colon, then the last cell 1  reference. 5. Press enter.
To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel's powerful SUMPRODUCT function. 1. For example, the SUMPRODUCT function below calculates the total amount spent. Note: the SUMPRODUCT function performs this calculation: (2 * 1000) + (4 * 250) + (4 * 100) + (2 * 50) = 3500. 2. The ranges must have the same dimensions or Excel will display the #VALUE! error.