Function

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

Download

Author(s) : Onetastic ★
Category : Table
Last Updated : April 22, 2023
Requirements : OneNote 2010 or above
Watch this short video to learn more about this macro
Changelog :

April 22, 2023 (E35B40) - Onetastic ★
Now preserves the formatting in the target cell

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

Comments

Name
Comment
Onetastic ★ - 2023-04-22
TinkSley: Updated the macro to preserve the alignment
TinkSley - 2023-04-21
Macro changes the alignment of the cell contents.
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