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



You need Onetastic Add-in
for OneNote to run this macro.
Download Onetastic
Author(s) : Omer Atay
Category : Table
Last Updated : April 24, 2018
Requirements : OneNote 2010 or above
Screenshot :


~ value decided at runtime ~
Select the function to apply to the cells
Changelog :

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

June 20, 2016 (60C751) - Omer Atay
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 - Omer Atay
Initial version


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?
Omer Atay - 2017-04-23
Philippe J. Bruno: I am not sure how your table looks exactly. You can send a sample page to and tell where your selection is before running it and we can diagnose