Thread: Counting values in columns of data with criteria

I have a head-scratcher that seems so simple but I just can't find my way about it

Have data in three columns and want to count how many people at each location have a particular status (3 possible values for status). E.g:


Name Location Status
John London Trained
Ann London Untrained
Sarah Newcastle Incomplete
Steven Derbyshire Trained

Need to generate a table that would look something like the one below in order to see how many people at each location have the status of trained, untrained and incomplete:

Trained Untrained Incomplete
London 6 7 0
Newcastle
Derbyshire


I though of using DCOUNT but that doesn't seem simple enough. Can anyone help??