Get the unique count of column on the basis of other column's data

Hi All,

I have three columns (A,B,C) in sheet and I need to sum column C data where data in A = *AB* AND data in column B is "*ype1*"


A B C
ABC type1 1
DEF type2 0
ABC type2 1
XYZ type1 1
ABC type1 0
DEF type1 0


Also I need to count the unique values in column C when below two conditions are satisfied:

Cond 1: Column a has *AB*
Cond 2: Coumn B has *ype1*

Thanks in advance

Try these:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

this last formula needs to be confirmed with CTRL+SHIFT+ENTER to work, not just enter.

Try:

Please Login or Register  to view this content.

CSE confirmed