Hi all

I have a database that has a date range, a territory look up range and
a sales value range by Category..

Src Date Territory Sales Value Category
09/01/2007 AAA 1.00 Product
09/01/2007 BBB 1.00 Product
09/05/2007 CCC 1.00 Product
09/05/2007 AAA 1.00 Service
09/07/2007 BBB 1.00 Service
09/07/2007 CCC 1.00 Service
09/11/2007 AAA 1.00 Product
09/11/2007 BBB 1.00 Service

I have a second list that has agents that have from 1 to 13
territories as their payment criteria.
Agent Territory 1 Territory 2
Jones AAA CCC

I need to be able to create a formula that will look up with in a
defined date range (say 09/03/2007 to 09/10/2007), the value (Sum) of
the orders that have assigned to these agents based on all of their
assigned territories as shown in the second tabel above.

Many thanks for any help. Much appreciated.

Best
Prasad