View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gocush[_29_] gocush[_29_] is offline
external usenet poster
 
Posts: 252
Default How to sum a column based on the choice of autofilter?

All of the Subtotal functions work on filtered data (visible cells only)

"Mr.G" wrote:

Hello,
I must sum the columns based on the criteria I choose in
the autofilter.Does anyone have a clue how to to
this.Hence, I only want to sum the visible cells.

I appreciate all respons.
Mr.g
-up north