Function

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

Download

Author(s) : Omer Atay
Category : Table
Last Updated : April 24, 2018
Requirements : OneNote 2010 or above
Screenshot :

Function

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

Comments

Name
Comment
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.
$14,000
$23,342
------------
0
Also, if there are leading spaces in the numbers, it will not recognize them
14000
23342
------------
23342
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?