Most valuable professional
  • Hot Topics

Excel Count unique text entries with multiple criteria

I am trying to count unique text 'Species' entires in column 'C' on a separate Worksheet (within the same workbook) with multiple criteria. The data are organized as follows (in 'Worksheet'): Row# 1 2 3 4 5 6 7 8 9 I have attempted to calculate the number of unique 'Species' during survey '1' at site 'a' using the following formula: =SUM(IF('Worksheet'!$B$2:$B$9="a")*('Worksheet'!$A$2:$A$9="1", 1/(COUNTIFS('Worksheet'!$B$2:$B$9, "a", 'Worksheet'!$C$2:$C$9, 'Worksheet'!$C$2:$C$9, 'Worksheet'!$C$2:$C$9, "1"))), 0) but it says there is an error in my formula. Please help! Thanks, meowerson

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of November 14, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel