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
cell H2:
=COUNTA(UNIQUE(FILTER(B2:B, REGEXMATCH(D2:D, "Post.*"))))
cell I2:
=COUNTA(UNIQUE(FILTER(B2:B, REGEXMATCH(D2:D, "Trans.*"))))