Matt

SubTotal ? Or use an Advanced Filter to extract unique values and then use
SUMIF. Or maybe a Pivot Table ?

Regards

Trevor


"cardinalred" wrote in message
...
I have imported data from a database into Excel. An example:

AWGM USD 10000
AWGM USD 50000
BGM USD 5000

These are in columns and rows. I would like to sum values in the third
colum
for AWGM USD, which would be 60000. I cannot find a function to lookup
like
values in column 1(AWGM) and return the summed value of the respective
data
from column 3 (60000). Any help?
Matt