Search code examples
filtergoogle-sheetsgoogle-sheets-formulacountifcount-unique

How would I find the Unique Entries using the COUNT Formula?


I am looking to find the Total Number of users opted into certain campaigns (Columns G-J). I'm not sure if I am using the correct form of the Count/CountUnique/CountIf formula when calculating the amount.

I've tried the CountUnique for 1 of the columns but I'm not sure if that number is correct either.

Sheet: https://docs.google.com/spreadsheets/d/1N2qB5Uqs58VpLF58-XUKQd2UIns6yoNElp1FilwvL1A/edit?usp=sharing


Solution

  • cell H2:

    =COUNTA(UNIQUE(FILTER(B2:B, REGEXMATCH(D2:D, "Post.*"))))
    

    cell I2:

    =COUNTA(UNIQUE(FILTER(B2:B, REGEXMATCH(D2:D, "Trans.*"))))
    

    0