Count unique values with multiple criteria

[Jak7217]

Hey All:

I am attempting to count unique text if criteria in the same row is met. Below I posted an attempt - what I am trying to do is count the unique number of text variations in column C when column A is equal to 05.

=SUM(IF("05"=A1:A15,1/(COUNTIFS(A1:A15,"05",C1:C15,C1:C15)),0))

Once I figure out how to fix the formula above, I also want to expand it so that it will only count unique if A = 05 and F = 6.

=SUM(IF("05"=A1:A15,1/(COUNTIFS(A1:A15,"05",F1:F15,"6",C1:C15,C1:C15)),0))

Can you please help me fix my formulas?

 

[Fluff]

Duplicate to: Count if unique

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.