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 : April 08, 2024
Requirements : OneNote 2010 or above
Watch this short video to learn more about this macro
Screenshot :


Decimal Symbol
Thousand Separator
Prefixes to Ignore (comma separated)
Changelog :

April 08, 2024 (4F7283) - Onetastic ★
Added new Settings dialog to allow changing decimal symbol and thousand separator. Also can now handle customizable set of prefixes like $ sign and keeps the alignment and prefix in the target cell. Access these options from the Settings menu for this macro

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


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.
Also, if there are leading spaces in the numbers, it will not recognize them