using the countif function
 

I am trying to get data that is listed in two seperate columns. For instance:
Column C has text fields and I know how to use the countif function to
locate it- however I also need the number value in column D that corresponds
to the text record in column c

column c column d
walmart $50.00
aol $25.00
I want to be able to pull all the walmart entries with the corresponding
money value in order to total up the amounts.