Results 1 to 4 of 4

CountIF Visible Cells only

Threaded View

mlucas.ftw CountIF Visible Cells only 08-17-2009, 10:15 AM
NBVC Re: CountIF Visible Cells only 08-17-2009, 10:27 AM
mlucas.ftw Re: CountIF Visible Cells only 08-17-2009, 10:46 AM
Completionist Re: CountIF Visible Cells only 02-25-2014, 02:17 AM
  1. #1
    Registered User
    Join Date
    08-11-2009
    Location
    Bournemouth, UK
    MS-Off Ver
    Excel 2003
    Posts
    2

    CountIF Visible Cells only

    Hi

    I've tried searching (and google'd) for a solution to my problem but i'm stuck, please bear with me here as it's been a very steep learning curve for me over the last few weeks trying to grasp VBA in excel:

    I've setup a worksheet whereby rows can be Autofiltered between a start and finish date via a Userform which (after much mucking about with UK/US dates) seems to be working nicely now.

    With the results of the Autofilter, i wish to count certain entries (in this case entries that are in column F) in the remaining visible rows.

    The Workbook is about 'Cases' worked, and column F relates to how the 'Case' is cleared (Call, Letter, Referral). Effectively I want to be able to count 'Call', 'Letter' and 'Referral' entries once the Autofilter has been applied.

    Any help on this would be hugely appreciated.

    Thanks
    Last edited by mlucas.ftw; 08-17-2009 at 10:47 AM. Reason: Problem solved

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1