How do I set multiple parameters using VLookup

  • Thread starter Danelle Boling, Sales Analyst
  • Start date
D

Danelle Boling, Sales Analyst

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.
 
T

Toppers

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
 
Top