Prev: Pivot Table  replace numbers with a text
Next: AltF6
From: Canon on 6 Apr 2010 06:50 Excel 2007 How can I calculate columns when I use the filter? The calculated numbers do not always match what they should be.
From: RonaldoOneNil on 6 Apr 2010 07:00 Look up the SUBTOTAL function in help "Canon" wrote: > Excel 2007 > How can I calculate columns when I use the filter? > The calculated numbers do not always match what they should be.
From: ozgrid.com on 6 Apr 2010 07:09 SUBTOTAL Function http://www.ozgrid.com/Excel/excelsubtotalfunction.htm  Regards Dave Hawley www.ozgrid.com "Canon" <Canon(a)discussions.microsoft.com> wrote in message news:A3188127CB8C4DD8BDCE98916FB07411(a)microsoft.com... > Excel 2007 > How can I calculate columns when I use the filter? > The calculated numbers do not always match what they should be.
From: Canon on 6 Apr 2010 07:18 The column I want to calculate is always the same, but I have to change the values of the filter, and I would like it to automatically calculate each time I do this. "RonaldoOneNil" wrote: > Look up the SUBTOTAL function in help > > "Canon" wrote: > > > Excel 2007 > > How can I calculate columns when I use the filter? > > The calculated numbers do not always match what they should be.
From: Fred Smith on 6 Apr 2010 19:26 Ronaldo understood you. The solution is the Subtotal function. You want to total the visible cells. Help explains it well. Regards, Fred "Canon" <Canon(a)discussions.microsoft.com> wrote in message news:C689222AB79C4228B5CA73A52B140773(a)microsoft.com... > The column I want to calculate is always the same, but I have to change > the > values of the filter, and I would like it to automatically calculate each > time I do this. > > "RonaldoOneNil" wrote: > >> Look up the SUBTOTAL function in help >> >> "Canon" wrote: >> >> > Excel 2007 >> > How can I calculate columns when I use the filter? >> > The calculated numbers do not always match what they should be.

Pages: 1 Prev: Pivot Table  replace numbers with a text Next: AltF6 