ExcelBanter - What's this: [Sales] ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - What's this: [Sales] ? (https://www.excelbanter.com/excel-worksheet-functions/257956-whats-%5Bsales%5D.html)

What's this: [Sales] ?

I am looking at a Worksheet where it contains the folllowing formula:-

=SUBTOTAL(109,[Sales])

I can see and understand what the formula is doing and why it is doing it.

I know what the 109 means.

What I don't understand is the:-

[Sales]

- part.

I have checked the Worksheet and there is no Range Name defined.

My question is: what is the:-

[Sales]

- part.

It appears to be some kind of Range Name (array? maybe).

TIA for any replies.

What's this: [Sales] ?

It is a column in a table, Sales is the heading for that column.

--

HTH

Bob

"trip_to_tokyo" wrote in message
...
I am looking at a Worksheet where it contains the folllowing formula:-

=SUBTOTAL(109,[Sales])

I can see and understand what the formula is doing and why it is doing it.

I know what the 109 means.

What I don't understand is the:-

[Sales]

- part.

I have checked the Worksheet and there is no Range Name defined.

My question is: what is the:-

[Sales]

- part.

It appears to be some kind of Range Name (array? maybe).

TIA for any replies.