Live Data from dropdown list

Hi,

Basically what im after is how can i get data from an drop down list?

For example in the image below i have a column called "status" which has an drop down list i can choose from (completed, pending, compliance etc) I want an data to show me how many has been completed or pending and each time i change the status the data will update

i.e.

Completed = 4

Pending = 7