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/excel-subtotal-function.htm -- Regards Dave Hawley www.ozgrid.com "Canon" wrote in message news:A3188127-CB8C-4DD8-BDCE-98916FB07411(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" wrote in message news:C689222A-B79C-4228-B5CA-73A52B140773(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 textNext: Alt-F6