Calculate Filtered Columns

C

Canon

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

Canon

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

Fred Smith

Ronaldo understood you. The solution is the Subtotal function. You want to
total the visible cells. Help explains it well.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation Time 2
How to remove automatic calculate function? 3
Using Filter more than once 2
Missing Filtered Data 1
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had 2
Average value only for the filtered area.. 4
Dates in Excel 2007 5
Filter Subtotal Problems 5

Top