Spreadsheet Aggregation Rows vs. Aggregation Columns
An aggregation cell is often defined as an aggregation function
(e.g. SUM, AVG, MAX, MIN and etc) over a group of other cells.
We say a row is an aggregation row if the cells of the row are
aggregation cells.
Similarly we say a column is an aggregation column
if the cells of the column are aggregation cells.
For example, the two figures below show the aggregation rows and
aggregation columns in a spreadsheet.
Example Questions.
Example 1.
Please look at the spreadsheets on the left and try to answer the following
questions.
Does this above spreadsheet contain aggregation rows? Answer: No
Does this above spreadsheet contain aggregation columns? Answer: No
Example 2.
Please look at the spreadsheets on the left and try to answer the following
questions.
Does this above spreadsheet contain aggregation rows? Answer: Yes
Does this above spreadsheet contain aggregation columns? Answer: Yes
