Results 1 to 8 of 8

Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2008
    Location
    global
    Posts
    4

    Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria

    Hi everyone,
    I have been working on this formula for a while but cannot seem to get it correct.
    I have 3 sheets.
    Sheet 1 - some codes and dates to be used in Sheet 3 in dropdown lists. Simple enough.
    Sheet 2 - the data (column A is Family Code, Column B is Item Code, Column 3 is # Sold, and Column D is Date Sold. There are about 200 rows with duplicates of item code.
    Sheet 3 - I need a report based on the following:
    I would like the user to select the family code, the report start date and the report end date from dropdown lists. This would in turn display the item code and the total number sold (from highest to lowest OR I can sort later).

    How complicated is this? I was hoping to keep this simple for the user.
    The file is attached.

    Any help would be GREATLY appreciated. Thank you.
    Regards, GTJ
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Concatenate multiple cells based on specific criteria
    By satkadeb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2011, 08:50 AM
  2. Deleting rows based on True/False Criteria
    By CatherineN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2007, 02:40 PM
  3. Finding top 2 values per group based on multiple criteria
    By schuc in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-22-2007, 10:51 PM
  4. Count number of cells based on multiple criteria
    By Cumberland in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-11-2007, 11:28 PM
  5. count if multiple criteria
    By blackstar in forum Excel General
    Replies: 5
    Last Post: 12-19-2006, 06:39 PM

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