View Single Post
  #1   Report Post  
cardinalred
 
Posts: n/a
Default summing multiple rows with like references

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