I know there must be a worksheet function to do what I am doing by various
degrees of filtering and sorting, so I thought I'd ask here. Basically:

Column A contains data on work location, eg, IHR, CPD, ED
Column B contains data on whether or not someone passed or failed a test, eg
P or F

I need to know, how many people from each work area passed and failed a
test. For example, if data in Column A = IHR, how many people (in that work
area) passed the test and how many failed the test

Currently, Im sorting the data to get all my IHRs grouped together, then
adding blank rows below each work location and counting the # of Ps and Fs
for that "group". I know there must be an easier way. Assistance is much
appreciated.
Thanx.