Use sum, average, etc. functions on tables. Select a cell, a column or a row to apply the functions.


Author(s) : Onetastic ★
Category : Table
Last Updated : November 25, 2022
Requirements : OneNote 2010 or above
Watch this short video to learn more about this macro
Screenshot :


Select the function to apply to the cells
Changelog :

November 25, 2022 (FBAE15) - Onetastic ★
Added menu with each of the functions

April 24, 2018 (6A2262) - Onetastic ★
Added support for calculating functions in nested tables

June 20, 2016 (60C751) - Onetastic ★
Re-written with the new Macro Language to take advantage of cleaner syntax and performance improvements

These versions are no longer supported:

March 09, 2013 - Onetastic ★
Initial version


Derrick - 2019-01-23
Only works on pure numbers in the cells.  If numbers are written as financial figures, it will not recognize them.  Ex.
Also, if there are leading spaces in the numbers, it will not recognize them
Omer Atay - 2018-04-24
Karen: Updated the macro to support nested tables
Karen - 2018-01-17
I often use tables inside of tables to keep things neat.   This marco does not work for tables inside of tables even if you select a single row or column in that subtable.
              Error message "please select cell(s) from a single table"
Is there a way to get this to work on tables inside of tables?