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.
Next. I seem to be unable to use the SUM function in excel. Everytime i use the sum function, my result returns as 0. The correct result returns if i use the + function, ie, A3 = a1+a2.I have tried every possible cell format for both the range of numbers and for the formual cell. have also removed all formatting... show more I seem to be unable to use the SUM function in excel. Everytime i use the sum function, my result returns as 0. The correct result returns if i use the + function, ie, A3 = a1+a2.