How do I set multiple parameters using VLookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to sum multiple matches to a vlookup command 2
summaries on alternative sheets 6
vlookup question 7
Can I create a multiple LOOKUP formula with 'then' function??? 8
Vlookup with multiple conditions? 2
If a cell contains a value then sum another cell. 3
vlookup using 2 reference columns 6
vlookup with 2 sets of criteria 2

Back
Top