Counting Instances of Companies in a Separate Table: Need Help!

Hi i have a table with repeated company rows due to a different row relating to that company. I have created a seperate table with deduped companies. I simply want to look up the other table and count the number of instances where the company is in a column to give me a count on the number of pieces of info relating to that company. Lookup doesn’t do a count and claygen doesn’t like it either. Any pointers would be much appreciated. Thanks!