COUNTIFS - Unique value, avoiding duplicates in another column.

[JazzSP8]

Hey All

I need an Excel 2013 formula to find the count of how many times a value appears in a column, with a unique value in another column - For example;

If I wanted to count 'Bathroom' then it would return 2 and for Kitchen it would return 1.

I've been messing around with COUNTIFS but can't seem to get it to work.

Can anyone help?

 

[Fluff]

How about

=SUMPRODUCT(--(FREQUENCY(IF(B2:B8="Bathroom",MATCH(A2:A8,A2:A8,0)),ROW(B2:B8)-ROW(B2)+1)>0))

 

[JazzSP8]

Excellent - That seems to do the trick!

Thanks Fluff - I'd never have got to that the way I was going

 

[Fluff]

You're welcome & thanks for the feedback.