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.
Clinical social workers earned a median salary of $51,930 in 2014, the BLS reports. The best-paid in the industry made $76,940, while the lowest-paid earned $32,060. The metropolitan areas that pay clinical social workers the best are all in California and include Redding, Napa and Vallejo.