Hi,

The range has been converted to a list (Ctrl+L or Data List). Once you do
that, you can insert a total row which will allow you to select the function

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Totteridge Ram" wrote in message
...
I have a MS Excel B/S template with the formula =SUBTOTAL(101,[2008]), and
when the cell is selected, a little arrow appears and it allows me to
select
the SUBTOTAL function (sum, average, min, max, etc).

This is brilliant - anyone know how this is achieved? I can't find any
macro or indeed any range named 2008.