View Single Post
  #1   Report Post  
Telly
 
Posts: n/a
Default SUMIF using VLOOKUP as criteria

Is the SUMIF function able to use a VLOOKUP as a criteria? I am trying to add
numbers having the same account number, where the account number and numbers
to be added are in another workbook. Do I put the VLOOKUP criteria in quotes?
Here's what I have:

=SUMIF(range in the other workbook showing account numbers, VLOOKUP(cell in
current workbook, range in other workbook,column in other workbook, false),
sumrange in other workbook)

Is there another way to do this? Thanks.