Lookup with multiple finds

[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

 

[Domenic]

Hi,

Try,

=SUMIF(A1:A4,"TVM",B1:B4)

Hope this helps!

 

[Frank Kabel]

Hi
try
=SUMIF(A:A,"TVM",B:B)

 

[LAF]

Thank you. It worked and is just what I'm looking for