I have a text column A with different values and a column B with numeric values. I would like to sum column B for all the different text values in column A (i.e. column A = 'ABC', sum(column B))

How do I create an aggregate formula for this? I've tried using sum_if("Table1"."Column_A" in ('%ABC%','%XYZ%'),"Table1"."Column_B",0) and  sum_if("Table1"."Column_A" like  ('ABC','XYZ'), "Table1"."Column_B",0) l but I keep getting error messages. I'm not sure why that is, please kindly assist.