Summing Results Based On A Specific Date

[JPP]

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

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

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

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


Thanks

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[JPP]

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

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

Always a pleasure, never a chore :

+-------------------------------------------------------------------
+-------------------------------------------------------------------