How do I set multiple parameters using VLookup
 

I am wanting to set parameters for one total made up from different varibles
in multiple columns.
Example: Figuring gross sales for a sales representative in a particular
region under a certain customer patch area for specific product.

How do I set multiple parameters using VLookup
 

SUMPRODUCT is a likely candidate:

=SUMPRODUC(--(A1:A100=Region),--(B1:B100=CustomerArea),--(C1:C100=SalesRep),--(D1:D100=Product),--(E1:E100))

where Column E are sales figures

Region,CustomerArea etc can be placed in cells

NOTE: SUMPRODUCT cannot use total columns but must be specified ranges of
same size i.e. A:A is invalid.

HTH

"Danelle Boling, Sales Analyst" wrote:

I am wanting to set parameters for one total made up from different varibles
in multiple columns.
Example: Figuring gross sales for a sales representative in a particular
region under a certain customer patch area for specific product.