Excel sum unique entries

[jmodo]

I am trying to do a unique sum of records using this code:
SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""), IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""))>0,1))

It works great, BUT I want to add in one more condition to see that the unique records have a matching field C=4 in the records C2:C10. How do I do this?

Thanks alot!!!
J

 

[SkipVought]

J,

What do you mean by a " unique sum of records "?

Does that mean that the unique sum of the following is 6?
[tt]
1,1,1,2,2,3,3
[/tt]
because I get 3, which, to me, looks like a COUNT of unique values.


Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

Also, you might post a data example and what you expect.

Skip,
[sub]
[red][/red]
[/sub]

 

[jmodo]

I have titles that have associated values such as

Col A Col B
MyTitles MyValues
____________________

Title1 4
Title2 1
Title1 3
Title1 2
Title3 4
Title3 4

I need to get the number of unique titles with value =4
Answer: 2 <- this is what I need
here would be the data selected:
Title1 4
Title3 4

 

[jmodo]

I'm just not sure how to add in the other condition where value=4 into the code above.