How to sum a column on OneNote like Office Excel

OneNote is a powerful tool to keep track and calculate expenses and incomes. However, when it comes to summing up numbers, especially for a column or table,  we know how irritating it is to sum all the columns at the end of the table. Table Sum Toy is an excellent add-on and is now updated to work with Office OneNote, and it can do all those summing up simple maths for you. Let’s learn how to sum a column on OneNote

How to sum a column on OneNote

Download and install the add-on. Restart OneNote, and then you can use it to Sum values in a table like Excel.

  • Select a Table which has those numerical for you and hit the Table Sum Addon.
  • Done that a new row is inserted at the end of the table which contains all the values of cells summed up for every column, i.e. It automatically calculates the sum of every column in One Note Table
  • Special characters and non-numeric which comes in between in case is skipped. So even if you have a very complex table with Lot of Alphabets, it will not fail you.

OneNote TableSum

OneNote can do a lot of mathematical calculations now. You can do 1=1, square root, average, trigonometric function, but it cannot do a column total, which is a shame. I wish Microsoft had, ie enabled so it can make everyone’s life so easy.

Video Demo to sum a column on OneNote

What can it not do?

  • It does not work on Multiple Tables. So you can do this on only one table at a time.
  • Cannot calculate selected column values.

Download  | This is an old toy and used to work with Office 2007 and now updated to work with 2010 and above. Thanks, John Guin.

PS: In case your other tables are getting the blank row when calculating for other tables, make sure you have selected tables correctly

Leave a Reply