Macro changes the alignment of the cell contents.

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

Karen: Updated the macro to support nested tables

I often use tables inside of tables to keep things neat.   This marco does not work for tables inside of tables even if you select a single row or column in that subtable.
              Error message "please select cell(s) from a single table"
Is there a way to get this to work on tables inside of tables?

Philippe J. Bruno: I am not sure how your table looks exactly. You can send a sample page to support@getonetastic.com and tell where your selection is before running it and we can diagnose

Hi Omer, is it possible that this macro is now broken? I know it is a complicated one, but I cannot get it to work this morning (I do not use it often, but this morning I needed it and it does not work). It keeps saying "The selected cell must be empty."

Doenst SUM decimals.

Having an issue with function macro - it screws up formatting of my entire table. Anyone had this issue/know how to fix it?

Thanks, Tim. There was also a blog post about this macro available at: http://omeratay.com/onetastic/?i=macro-function

Some info for users who are wondering (like I was) how this works:
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.