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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
<(E-Mail Removed)> wrote in message
news:47bf2ea5-2e24-4c6e-a5d2-(E-Mail Removed)...
> 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
>

Thanks Don,

I got it.


On Mar 28, 5:12*pm, "Don Guillett" <dguille...@austin.rr.com> wrote:
> You can help yourself by taking a look AGAIN at the help index for SUBTOTAL.
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com<my.wandering.m...@gmail.com> wrote in message
>
> news:47bf2ea5-2e24-4c6e-a5d2-(E-Mail Removed)...
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -