# Count distinct text values with multiple criteria

Highlighted
Occasional Visitor

# Count distinct text values with multiple criteria

Hello,

I have a data set that i wish the count the number of distinct text values in a column given certain criteria from another column.

Please see attached "Example data Set".  I would like the count of distinct text values from the column "name" given that the Value in Column "rank" is C1.

Thank You!

3 Replies
Highlighted

# Re: Count distinct text values with multiple criteria

As variant

``=SUMPRODUCT((\$B\$2:\$B\$13="C1")/COUNTIFS(\$A\$2:\$A\$13,\$A\$2:\$A\$13&"",\$B\$2:\$B\$13,\$B\$2:\$B\$13&""))``
Highlighted

# Microsoft Excell: calculate 1st Sun, 2nd Sun, 3rd Sun, 4th Sun, and 5th Sun

I am using Microsoft Excell on a Mac computer. I have created the attached 4 Week Microsoft Excell Spreadsheet Calendar Template, which includes calendar dates. I use the calendar repetitively. I am looking for a way to place in cell C1 the date for any particular Sunday, and calculate 1st Sun, 2nd Sun, 3rd Sun, 4th Sun, and 5th Sun of the month, in cells C11, C23, C35, and C47 respectively.