An Example of Bracketed Column Name

This is an example based on post at: http://excelexperts.com/brackets-in-formulas
Bracketed column name can be seen when you choose "Show Total Row" with Data Table. When you right-click on Data Table and choose "Show Total Row" and choose "SUM", this is what you get within a Total cell. "Meal" within brackets refers to column "Meal" within Data Table, not a named range. So, "SUBTOTAL(109,[meals])" means "SUM of 'Meals' column", where "Meals" is a column within Data Table.
Maybe "Sum" cell was copied away from a Data Table, and that is why it looked strange.
Look at example file attached.
Attachment | Size |
---|---|
BracketedTotal.xlsx | 9.21 KB |
- Almir's blog
- Login or register to post comments
- 5073 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago