T
trip_to_tokyo
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.
=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.