Thread: Calculate Filtered Columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
  
Posts: 117
Default 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.
Reply With QuoteReply With Quote