+ Reply to Thread
Results 1 to 2 of 2

Sum & autofiltering

  1. 01-03-2005, 08:42 PM #1
    Edward Cheung
    Edward Cheung is offline
    Registered User
    Join Date
    01-03-2005
    Posts
    1

    Sum & autofiltering

    Hi,

    After I select an item in autofiltering,
    how can I sum the number of those items.

    Eg
    I selected banana in autofiltering,
    then there are like 5 cells in that row containing the word "bananas"
    and other unrelated cells are hide.

    How can I just sum the number of bananas

    Thank you.
    Any response or feedback is appreicated

    Edward
    Reply With QuoteRegister To Reply
  2. 01-04-2005, 01:46 AM #2
    gocush
    gocush is offline
    Registered User
    Join Date
    10-12-2003
    Posts
    34
    Activecell.CurrentRegion.SpecialCells(xlCellTypeVisible)

    Should define the range of cells which are still visible after filtering.

    Then try using the CountIf function to get the count of "banana" in the above range
    Paul
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1