Thread: Excel Woes

  1. #1
    Its not rocket science vasanth's Avatar
    Join Date
    Jan 2002
    Posts
    1,683

    Excel Woes

    Hi,
    I have a problem with using auto filter. i have a column which at the end has a total.. i want this total to chnage based on the filter choosen.. i want the total of only the displayed rows when i filter ...

  2. #2
    &TH of undefined behavior Fordy's Avatar
    Join Date
    Aug 2001
    Posts
    5,793
    Use subtotal as the function with 9 as the first param and the range as second

    [edit] moved to tech board

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. using Excel to connect to external data source
    By George2 in forum Windows Programming
    Replies: 4
    Last Post: 05-01-2007, 10:07 PM
  2. Exporting a DataTable to Excel (.NET)
    By Trauts in forum C# Programming
    Replies: 0
    Last Post: 07-29-2005, 01:03 PM
  3. Weird Excel behavior
    By Govtcheez in forum Tech Board
    Replies: 1
    Last Post: 12-03-2004, 01:53 PM
  4. C++ Builder and Excel files
    By mfdemi in forum Windows Programming
    Replies: 3
    Last Post: 09-24-2004, 01:51 AM
  5. Print a File via Excel
    By ginoitalo in forum C# Programming
    Replies: 2
    Last Post: 05-10-2002, 12:33 AM