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 ★ November 25, 2022 (FBAE15) - Onetastic ★ April 24, 2018 (6A2262) - Onetastic ★ June 20, 2016 (60C751) - Onetastic ★ These versions are no longer supported: March 09, 2013 - Onetastic ★ |
$14,000
$23,342
------------
0
Also, if there are leading spaces in the numbers, it will not recognize them
14000
23342
------------
23342
Error message "please select cell(s) from a single table"
Is there a way to get this to work on tables inside of tables?
1. this macro is already in Onetastic as of today (March 19, 2013) so you don\'t need to download it separately.
2. It includes 6 functions - Sum, Average, Count non-empty, Count numbers, Min, Max.
3. It performs a calculation once. That is, it is NOT inserting a formula like in Excel which auto-recalcs when you change the values.
4. To operate on a single row/column of numbers - have an empty cell beside/underneath them, then select them and the empty cell, then do the function
5. To operate on multiple rows/columns - have an empty row beside/beneath the set of data, select it, do your function.
6. In other words, to do a single line of numbers, select the data plus one empty cell. To operate on a matrix, select an empty row or column next to the matrix, for the results.