View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan
 
Posts: n/a
Default 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.