How do I highlight all rows and columns with numbers in a table at once in Numbers?

Hi PepperpotsinAustralia,

I enjoy using the Charm of Numbers and the powerful way that tables allow Header Rows, Header Columns and Footer Rows.

This Table named Fruit has one Header Row, two Header Columns and one Footer Row.

The Body Cells C2:E4 contain some silly made up numbers, simply to help me check the formulas.

Formula in Header Column Cell B2 is SUM(2:2)

That SUMs all Body Cells in Row 2 and ignores all Column Header Cells.

Fill down.

Formula in Footer Cell B5 is SUM(B)

Fill right.

Please reply with questions.

Regards,

Ian.

I am not clear on what this is in Excel to provide a proper answer. It sounds like you said you have a table of data (an Excel "table" as they define it, not a worksheet) and if you select all the data cells at once it will give you the sum of each column, the sum of each row, the sum of the entire set of data, and the "totals of each tie" (not sure what that means) all at the same time? I have not seen this feature. I don't use Excel very often, though. If you can point me toward this feature in Excel I will check it out.

In Numbers, if you click on a column letter or a row number to select that column or row you will see some stats at the bottom of the window. SUM, COUNT, AVERAGE and others you can choose from. Select the entire table to get stats for the entire table. There is no count of duplicates or summing of duplicates, if that is what you meant by "total of each tie".