If you only need the total (and not a list of every matching entry), you can
use sumif: =sumif(c:c,"Walmart",d:d)

"Susan" wrote:

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.