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.
Right-click on PurchaseAmount and select Add Total. The expression SUM(PurchaseAmount) is automatically added to a new row in the report. Type in Grand Total in the cell to the left and bold the row. Now that the details and grand total are in place, add the innermost level of grouping above the details, CustomerID.