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

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

LizG

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

LizG

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return the value from one range that does not exist in another 0
count unique values with auto-filter on 6
Count Unique Values in 1 Column based on Date Range in another Column 28
Count Unique Values 4
Count Unique Values 4
Count Unique Values in a entire column, not just range 20
Counting unique values in multiple columns 4
Counting text cells then multiplying by a value in another column 6

Top