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

  • #2
    Re: Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria

    How much are you willing to pay?

    Comment


    • #3


      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
      Check out our new reputation system. Click on the Like button under the post!
      _______________________________________________

      There are 10 types of people in the world. Those that understand Binary and those that dont.

      Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

      The BEST Lookup function of all time

      Dynamic Named Ranges are your bestest friend

      _______________________________________________

      Comment

      Working...
      X