vlookup multiple criteria

  • Thread starter Thread starter Jayme
  • Start date Start date
J

Jayme

I need a function to lookup a shop number and sum an amount for each
one:

a b
1 Shop # expense

2 427 $5.00

3 428 $10.00

4 427 $6.00

5 428 $2.00

etc.

I want to lookup all 427 in column a and add the coresponding amount
in column b. I need to know the total expense for each shop. Lookup
all 427 and add up the expenses; repeat this in a separate formula for
each shop.

I hope this makes some sense.

Thanks for your help.

Jayme
 
Jayme,

Take a look at the SUMIF function, you'll need something like:
=SUMIF(A1:A10,427,B1:B10)

Dan E
 
Back
Top