After you filter the rows in a list, you can use the AGGREGATE function to count the visible rows. This function was introduced in Excel 2010, and is similar to SUBTOTAL, but it has 19 functions, compared to SUBTOTAL's 11 functions.
A Medical Social Worker is a social worker who works in a medical setting such as a hospital, outpatient clinic, hospice, long-term care facility, or community health agency.
Additionally becoming an LCSW can afford clinical social workers more autonomy in their job, and is a requirement for clinical social workers who wish to enter private practice. Note: The designation for social workers who have their clinical social worker license varies by state.