# 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

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

How much are you willing to pay?

• 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!
_______________________________________________

[SIZE=8px]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[/SIZE]
_______________________________________________