I have individuals who are on probation. Each individual can have multiple records, each record shows their offense level (Felony or Misdemeanor). Some have multiple felonies, some have felonies and misdemeanors, some just misdemeanors. I need a count of those that have felonies regardless if they also have misdemeanors, and I need a count of those that have JUST misdemeanors. The felony count is easy because I don't care if they also have misdemeanor charges. How do I get the misdemeanor count?

The individual would count just once regardless of how many felonies or misdemeanors they have. I have been stumped on this for weeks!!!