I need a count total of leads assigned. However, I need to be able to do this via three dropdowns. One for AGENT NAME, as well as beginning and end date.

After choosing an agent name, begin & ending date from a drop down, I need to total how many leads they were given in the chosen amount of time.

3 Dropdowns. 1 Cell To Display Results. Info pulled from second tab.

Dates are in the following format : 1/2/2013


Thanks!

Hi JPP,

Any chance of you posting an example workbook? Makes it MUCH easier to provide you with solutions.

This is a basic example, but there is too much information in the original file to attempt to change it.... Thanks AGAIN though spencer!!

Try the below formula in D10 on the Totals sheet of your example.

=SUMPRODUCT((Leads!A2:A9=Totals!D7)*(Leads!B1:L1= F7)*(Leads!B1:L1<=G7),Leads!B2:L9)

Is that of help?

You'll need to tinker with it to fit your real workbook, but the idea is there and should make sense.

Thanks Spencer! That's the 2nd time you been able to solve my problem!

Always a pleasure, never a chore :)