Lookup with multiple finds

  • Thread starter Thread starter LAF
  • Start date Start date
L

LAF

I have a range with 2 columns. The first column is a description an
the second is a value.

TVM 89
test 34
TVM 342
test2 27

I need a function which will add all of the records with a descriptio
equal to "TVM". I used a VLookup, but it only brings in the firs
value, 89. Is there any way to pull them in so it returns 89+342=431
 
Back
Top