Prev: Pivot Table - replace numbers with a text
Next: Alt-F6
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" <Canon(a)discussions.microsoft.com> 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" <Canon(a)discussions.microsoft.com> 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 text
Next: Alt-F6