Formula on Column

Hi,
The data will be imported from excel. I need help to find
Scenario - In AA Project , the count of Consultant is 1 and count of senior consultant are 2.