Vlookup multiple lookup values and sumation

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I am trying to do a vlookup for 3 different search criteria for a long list
of data. I am trying to find the amount spent on an activitiy by location
and product. The end result is the amount based on those 3 categories. then
i need all the same activities for that product, in that location added up.
I am a novice with excel formulas so any help would be very much appreciated!
Thank you!
 
=SUMPRODUCT(--(activity_range=activity),--(location_range=location),--(product_range=product),amount_range)
 
seems closer than where i was but still not exact. returned a value of 0.
what do you mean when you write --? i'm sorry i'm a serious novice with
this.

On the first sheet i have the table that ai am trying to create and have the
3 words in various boxes that i am trying to search for in the larger sheet,
so have just selected those boxes. maybe i have to type in the actual words?
thanks very much fro your help.
 
If you give some cell references and column/range references then you
will get a solution which is tailored to your situation. What cells
and columns are you using? What are your sheet names? What formula did
you try?

The double unary minus, --, converts arrays of TRUE and FALSE to 1 and
0 respectively, so they can be treated arithmetically.

Pete
 
Back
Top