You can help yourself by taking a look AGAIN at the help index for SUBTOTAL.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Hi All,


I have a table with the following headers
Range (A1:L1)
segment 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
I have a list for which I filter this table according to segment and I
need to find the average of each visible column for respective years
and generate it into a new table

I have excel 2002 and Using Subtotal function gives error.

Can someone help me on this?

Thanks
vishnu