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.
If the SUM is returning 0, then the data is most likely not all text or the cells being summed are not all formatted as numeric, or they actually coincidentally sum to zero. In your sum formula: 1  Select the range.2  That is, in the formula =SUM(E1:E20) , then select the cells E1:E20.3  then press the F9 key.n your sum formula: 1  Select the range. 2  That is, in the formula =SUM(E1:E20) , then select the cells E1:E20. 3  then press the F9 key.