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

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...?

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

"Jean-Luc" wrote:

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...?

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

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.

"Jean-Luc" wrote:

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...?