Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel sum unique entries

Status
Not open for further replies.

jmodo

Programmer
Aug 2, 2006
43
US
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
 



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]
[glasses] [red][/red]
[tongue][/sub]
 



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

Skip,
[sub]
[glasses] [red][/red]
[tongue][/sub]
 
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
 
I'm just not sure how to add in the other condition where value=4 into the code above.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top