Results 1 to 7 of 7

Count in filtered list and display results in table on right of data

Threaded View

  1. #1
    Registered User
    Join Date
    03-30-2006
    Posts
    32

    Count in filtered list and display results in table on right of data

    I have a long list of delegates attending functions on different dates and need help with 2 problems:
    A) List has filters by date/venue etc but I will want the table to be visible even when list is filtered.
    B) I am using the following formula to count "=SUMPRODUCT(--($E$3:$E$728="Thursday 3rd September 2009"),SUBTOTAL(3,OFFSET($E$3,ROW($E$3:$E728)-MIN(ROW($E$3:$E$728)),,1)))" and this works but if I filter to another date then 3rd September shows 0.
    Last edited by raydaw; 08-27-2009 at 05:18 AM.

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