if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT
AHHHGGGGGGG!

Good Evening,

I am having difficulty writing an If statement on my spreadsheet. What
I did was I have 2 spreadsheets that the first one has a master lister
of data. It is sorted by the following:
Sheet #1 has the following
Date, File Number, "Orgin", Name, Number of QTY

What I am trying to do is to create I think If statements and counts to
pull this data from date ranges and list is out on a second excel
spreadsheet. Idealy this is what I want to accomplish.

Sheet #2

Week Ending
October 8th
Orgin and date are the key becasue I want it sorted by this.

A count of the files in the date range (Say Oct 1st - Oct 8th) filter
out duplicates) then the same for say Oct 9th-Oct 16th, Oct 17th-23rd
and so on. 2 packets of results for each orgin A & B.

Same for a count of the names in that period of time. Now I don't need
to eliminate duplicates for the names becuase some files have multiple
names

An add of the number of qty.

So I am trying to get my output to look like this.

Week ending
                        October 8th
Orgin:A (its either going to be orgin A or B
Number of files:         10 count without duplicates)
Number of names:     15 (count with duplicates)
Number of QTY          123  (sum)

                       October 8th

Orgin B
Number of files:        12
number of names      20
number of QTY         150

                        October 15 (same format as the 8th and so on)

Orgin A:

If anyone knows how I can even get started on this, I would be very
greatful. I have read alot on the IF statement, Count, DCOUNT and I am
getting lost!!!!!