Excel search for value add value next from colum
<p>So I need a bit of help I have a huge excel sheet with materials </p>

<pre><code>Material   Quantity 
AA          10
BB          11
CC          52
DD          60
AA          16
DD          10
FF          20
QQ          400
RR          25
TT          80
AA          10
AA          122
FF          11
FF          12
GG          1
TT          15
</code></pre>

<p>What I would like to be able to do is to select the Value from 1st colum, let's say look for AA and automatically to get the SUM off all the Quantity AA ( In this example 10+16+10+122 = 158)</p>