I am working on the status report, I have a column with multiple status, However i need the count for each status by supplier

Hi Team,

I am working on the status report, I have a column with multiple status, However i need the count for each status by supplier.

Kindly help me with calculation formulae.

Thanks in advance.

Rushi