Description | : | Use sum, average, etc. functions on tables. Select a cell, a column or a row to apply the functions. | |||
---|---|---|---|---|---|
Author(s) | : | Omer Atay | |||
Category | : | Table | |||
Last Updated | : | April 24, 2018 | |||
Requirements | : | OneNote 2010 or above | |||
Screenshot | : | ||||
Function |
|||||
Changelog | : | April 24, 2018 (6A2262) - Omer Atay June 20, 2016 (60C751) - Omer Atay These versions are no longer supported: March 09, 2013 - Omer Atay |
$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.