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.
The way to do this in Excel is to use the SUM function. The formulas below show you how to add up values in columns using a few different variations of the SUM function: To get the sum of values in a column (e.g. column B), use the following formula:=SUM(B6:B17). Here's how to have the sum appear directly beneath the last cell: 1  Drag your mouse cursor over the cells you want to add (e.g. B6 thru B17).ereâs how to use the Function Arguments dialog box to get the sum of values: 1  Click on the cell where you want the Total sum to appear (e.g. A21). 2  Press the equal sign (=) on your keyboard. 3  Click on the function drop-down list box (See Figure 1), on left side of the formula bar.