How to sum up a number of values with widgets


So I'm looking to create a widget that quickly shows me the number of times a value is represented. What I want to do is separate out a number of teams I have and see how many times each team has a "missing" value in it. I have rows broken down by team members. There's multiple columns, but their team name is one of them, and the status is another column which would be "missing" or "current". Basically, I want charts or summaries that give me a quick breakdown that shows me the number of "missing" from "team A" is 7. etc.