Count Unique Using Multiple Criteria

What version of Excel are you using. 16 is not a valid version.

If you delete A and write B or any letter associated with your products you will have the corresponding single count associated with the account.

Answer FLUFF's question (Greetings)

B19=SUM(IF(FREQUENCY(IF(INDEX($C$2:$G$12,,MATCH(MID(A19,SEARCH("product",A19),9),$C$1:$G$1,0))<>"",MATCH($B$2:$B$12,$B$2:$B$12,0)),ROW($B$2:$B$12)-ROW($B$2)+1),1))

Control +shift+enter

Sorry! 16.64

That is not the version, if you click on file & Account it will tell you what you are using. Something like 2019 or 2021 or 365

You must indicate the year of office you employ

e.g. 2010 2013 2016 2019 2020 or

office 365