Calculate Filtered Columns
 

Excel 2007
How can I calculate columns when I use the filter?
The calculated numbers do not always match what they should be.

Calculate Filtered Columns
 

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.

Calculate Filtered Columns
 

SUBTOTAL Function
http://www.ozgrid.com/Excel/excel-subtotal-function.htm


--
Regards
Dave Hawley
www.ozgrid.com
"Canon" wrote in message
...
Excel 2007
How can I calculate columns when I use the filter?
The calculated numbers do not always match what they should be.

Calculate Filtered Columns
 

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.

Calculate Filtered Columns
 

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
...
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.