vlookup - add

  • Thread starter Thread starter E Arredondo
  • Start date Start date
E

E Arredondo

Hi,

Is there a way of telling the "vlookup" function to bring the sum of all
occurrences of the searched criteria ?

like for example :


A B C D E F

1 1 23 1

2 1 30 =vlookup(D1,A1:B2,2,false) = 53
instead of 23 ?

3 2 15

4
 
Not that I know of, but in the circumstance you're considering, you
could use a sumif formula (=SUMIF(A1:A2, 1, B1:B2)) You could probably
use a SUM array formula in most circumstances where you might need to
do what you are describing as well. In that case, you would type
=SUM((A1:A2=1)*(B1:B2)) and then hit control-shift-enter all at once.
 
Back
Top