Calculate Filtered Columns

  • Thread starter Thread starter Canon
  • Start date Start date
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.
 
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.
 
Ronaldo understood you. The solution is the Subtotal function. You want to
total the visible cells. Help explains it well.

Regards,
Fred
 
Back
Top