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


Changelog  :  April 08, 2024 (4F7283)  Onetastic ★ 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 nonempty, Count numbers, Min, Max.
3. It performs a calculation once. That is, it is NOT inserting a formula like in Excel which autorecalcs 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.