count unique values in one column for a set value in another col.

  • Thread starter Thread starter Jean-Luc
  • Start date Start date
J

Jean-Luc

I am trying to count how many unique values (text) I have in one column, for
the row cases where a particular value exists in another column.
Perhaps some combination of Frequency function with Countif or Sumproduct...?
 
Jean-Luc said:
I am trying to count how many unique values (text) I have in one column, for
the row cases where a particular value exists in another column.
Perhaps some combination of Frequency function with Countif or Sumproduct...?
Click to expand...
 
I think you are looking for the SumIf command. Do a search for SumIf under
the help menu. I am pretty sure this will answer your question.
 
Back
Top