Announcement

Collapse
No announcement yet.

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

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.
    Here is the link to the file: http://www.savefile.com/projects/808690911

    Any help would be GREATLY appreciated.
    Regards, GTJ

  • Ger Plante
    replied
    Re: Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria

    Did you intend on listing all item codes for the selected family and the number of items sold for that Family/item code? Or do you just want to add up the number of items sold for that family regardless of different item codes? (between given dates).

    How much are you willing to pay?
    Ger

    Leave a comment:


  • Dave Hawley
    replied
    Re: Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria

    How much are you willing to pay?

    Leave a comment:

Working...
X