Hello

If i have a table with two columns as follows:

Col1 Col2
a390 5
a391 25
a404 15
b409 18
b580 20

Is there a way to use vlookup to find all the columns with a39 in and add the totals in column 2 together. So in the scenario above it would output a count of 5 + 25 for 30.