I have a spreadsheet set up with a filter in column AB so I can filter on
individual companies. Column AA then contains multiple status references ie
new, scrap, cascade

At the bottom of the sheet I want to be able to count how many of each
status from column AA we have for the company filtered in column AB.

Could someone please help.