Unique Count with Filter

[davidhall80]

Hello All

I am trying to come up with a formula for Unique Values in a certain column with a filter in a different Column.
For Example: A Unique Count of items in Column A if Column B = 1....So the result should be 3. Thank You Very Much

ColumnA............ColumnB
1............................0
1............................0
2............................0
2............................0
2............................0
5............................1
5............................0
10..........................1
15..........................1
15..........................0

 

[inactiveuserps07]

David, I'm a little confused here. If the result you want is 3, isn't that just a COUNTIF() on Column B for a value of 1? Do you really mean that you want a result of 30 (i.e., the sum of values from Column A where Column B = 1)?

If you do mean the latter, and assuming your sample range shown occupies A1:B10, use this:

=SUMIF(B1:B10,1,A1:A10)

 

[NARAYANK991]

Hi ,

Try this array formula , to be entered using CTRL SHIFT ENTER :

=SUM(IF($B$2:$B$11 = 1, 1/COUNTIFS($B$2:$B$11, 1, $A$2:$A$11, $A$2:$A$11)))

 

[Aladin Akyurek]

=sum(if(frequency(if(b2:b16=1,a2:a16),a2:a16),1))

 

[inactiveuserps07]

Ah, I see by others' replies what was likely meant. Ignore my suggestion.

 

[davidhall80]

Thank You the time. It works!

 

[Aladin Akyurek]

Thank You the time. It works!

A reminder. The formula with FREQUENCY is the faster option.